> Generally the solution for this is check that you have 
> the latest version of MDAC installed on your server.  
> However, you're running win2k, so you should already have 
> the latest drivers on there already.

As a point of MDAC trivia, there have actually been two releases of MDAC
since Win2K came out. MDAC 2.7 is the latest version.

> Otherwise, 40 queries on a page!!!!! Is that every page or 
> just one or two? I would suggest that maybe your application 
> needs some performance tuning. Look at how those queries 
> could be reduced in number, avoid using query of query, 
> most QofQ stuff can be better done using appropriate JOINs
> in SQL therefore making the database work for its money and 
> not CF, look at using stored procedures and caching your 
> queries.

All I can add to that is, "Amen, brother!"

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to