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-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]
