Yes all tables have indexes
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 12:06 PM
To: CF-Talk
Subject: RE: OT: SQL VS ACCESS
Have you established indexes??
---- Original Message ----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED],
Subject: RE: 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
