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]
