Just as an FYI: It seems CF 5 fixed the indexing thing. I just (like 2 hours ago...) setup a new CF 5 server & swapped the client store from Registry to SQL Server. I fired up Enterprise Manager expecting to have to add the indexes, and was pleasantly surprised to see that CF had already done it for me.
That would of course only apply to a new CF 5 server setting up a new client store in an empty DB, but anyways... Just my $0.02.... Best regards, Zac Bedell > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 18, 2002 4:43 PM > To: CF-Server > Subject: RE: NT error 232 & low performance > > > > 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 > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
