> i agree. one more thing i was told to check is to see > if the db was indexed or not, and see if we can get back > to storing them in the db. could it be that the client > variable db not being indexed is what made it so slow?
This could very well be the reason for its very poor performance. I know that, if you use SQL Server to store Client variables, the tables that CF creates are not indexed, and that you'll need to index them to get decent performance. > (i'm a very novice dba so if i sound dumb about it that's > why) : ) No need to apologize. An experienced DBA would probably expect CF to create indexes as appropriate for the tables it creates! I know that we've made the same mistake in the past. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
