Sorry for taking so long to respond, was pulled away.
This site is being hosted remotely. I am being told by tech support that to
speed things up I ought to be connecting to SQL 2000 directly. Huh?!
Is there something I ought to be doing aside from :
I set up a Access db and it takes
Hey Gil,
I had a similar issue with a site I set up on a shared hosting server
- even super-simple queries were at least 4 seconds. What I found is
that they had disabled the "Maintain Connections" setting for the
datasource. You'll find it under ColdFusion Administrator -> Data
Source -> Your D
Time the same call outside of ColdFusion - is it still that slow?
It definitely seems something is wrong - if it's just as slow outside of CF
then you can forget CF as a part of the problem and start troubleshooting
your network and database.
Let us know how it goes.
Jim Davis
From: mayo [mailt
Not a database expert but I've seen this happen before. Try restarting the
sql server, and check that the database hasn't run out of space (right click
on the db in enterprise manager, then properties)
_
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 4 August 2004 6:10 p.m.
To: CF
4 matches
Mail list logo