can't you cache those queries?
On Mon, 21 Mar 2005 23:08:12 +0100, Daniel Niklasson <[EMAIL PROTECTED]> wrote: > Sorry folks for the partial email. > > I have about 500+ categories now in my system. Every page that uses > genericAdmin and displays the categories filter is VERY slow. I�ve done some > debugging and farcry is doing a few hundreds > > q (Datasource=farcry_sportal, Time=0ms, Records=0) in > \farcry_core\admin\includes\cfFunctionWrappers.cfm @ 22:59:47.047 > > select objectid, objectname from nested_tree_objects > where parentid = 'C4360553-D693-EDC7-06918A698F459355' > order by nleft > > Does anyone got a quick sollution how to solve this problem? I think we�ll > end upp with about 1000 categories when we�re finished. > > Daniel > > > --- > You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- =+=+=+=+=+=+=+=+=+=+=+=+ Emanuel Costa site: http://www.emanuelcosta.com msn: [EMAIL PROTECTED] ICQ: 8013683 Orkut: Emanuel Costa Skype: Emanweb =+=+=+=+=+=+=+=+=+=+=+=+ "Education is a progressive discovery of our own ignorance." - Will Durant --- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
