getCategories() and Site Menu
Thanks for posting!
There are going to be a few different options for optimizing your code and for the most part, we will starting getting quite technical pretty much right away so I am not sure how far we'll get in the forum. For now though, could you give me a list of the exact fields you need to pull from the database?
With that, I can start exploring my first idea with you. The idea will revolve around creating a custom SQL query and pulling out only the exact fields you need. That will help bring down the overhead just grabbing the entire database will require. One thing to keep in mind here is that pseudo fields are going to take extra work in this method but there will likely be a MySQL way to get all the data needed so let's start with a list of fields and go from there.
Ross Fairbairn - Consulting
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/