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 :
<cfquery name="whatever" datasource="whatever">
</cfquery>
I set up a Access db and it takes 0.047 milliseconds to render. The same
table takes 4500-9500 milliseconds on SQL 2000.
I haven't done a php call -- well, because it looks as if it's the SQL 2000
connection.
Gilbert Midonnet
-----Original Message-----
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 1:10 AM
To: CF-Talk
Subject: EXTREMELY slow site, trying to troubleshoot
I'm building a site that is EXTREMELY slow even though there is no usage
except for myself and two or three other people.
Using CFMX and SQL 2000.
I've boiled it down to my database calls.
I thought perhaps it was my joins. But it's more than that even the
simplest
database call takes 4.5 seconds. The basic stuff is below and the full
page
is below.
<cfquery name="getPromos" datasource="RMG">
SELECT promoText.*
FROM promoText
</cfquery>
<cfoutput query="getPromos">
<p>#promoText#</p>
</cfoutput>
The code below, pulling 3 records took 4562 milliseconds. How can this be?
Thanks all for any suggestions.
Gil Midonnet
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
