been satisfied with them. I've never seen anything like this. At first I
thought I had too many includes (4) and too many database calls with too
many joins. Finally I pared a test page down to one database call
SELECT *
FROM categories
There are two fields (categoryID and categoryName) and 3 records in this
table.
The average tickcount is 4500 milliseconds
I created the same table in access and it averages 40-50 milliseconds.
The hosting company keeps saying that
1. they can't see anything wrong
2. it must be my coding (can't be if it's one call with no joins)
3. they have had no complaints from other other customers
CF code below
<cfquery name="getCategories" datasource="whatever">
SELECT *
FROM categories
</cfquery>
...
<cfquery name="getCategories">
#categoryID# - #categoryName# <br/>
</cfquery>
Gil Midonnet
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 11:13 PM
To: CF-Talk
Subject: Re: connecting to SQL 2000 directly WAS: EXTREMELY slow site,
trying to troubleshoot
No you shouldn't be doing anything different to connect to your
database, in fact, you could use Java objects to connect to your
database, however, because the resultsets returned would need to be
converted to ColdFusion query variables before being used by other
ColdFusion code this would be slower than simply using the cfquery
tags.
A table from an access db which selects in 0.047ms should not take
4500-9500ms to select after converting the same table to an MS SQL
2000 Server database. Although storing queries in memory can mitigate
some of the overhead of delivering your pages, there is definately
something wrong with their SQL Server configuration and it should be
dealt with. Other than severe overhead from multiple other
simultaneous connections to the SQL Server and/or firewall /
encryption between the ColdFusion Server and the SQL Server (which
isn't normal afaik), I can't think of anything offhand that would
cause this kind of lag.
> My site is extremely slow. I've narrowed it down to my
> database calls.
> 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.
> Thx,
> Gil Midonnet
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
