I'm guessing you're running CF and SQL server on a sissy girly box, no
wonder it's slow. Access don't need as many resources as SQL server, that
may explain the speed different.
So get rid of your sissy box, and get a monster machine!
I'm running on a 1.3ghz processor and 1.5 gigs of RAM
>From: "Bruce, Rodney" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT: SQL VS ACCESS
>Date: Tue, 12 Jun 2001 10:51:09 -0700
>
>I thought that SQL was suppose to be faster than ACCESS.
>
>I am running CF 4.5 with ACCESS 2000 and SQL 7.0
>
>I export/import my ACCESS tables into SQL
>
>Running the same pages/queries, SQL is on the average taking twice as
>long.
>
>Can anyone give me reasons for this or things I should look into to speed
>up
>the SQL.
>
>I have been trying to work with stored procedures to put more processing on
>the DB side, but this seems to be even slower, any ideas what I am doing
>wrong?
>
>Thanks
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
