Make sure all your fields that should be indexed are indexed. I think the
upsizing wizard forgets about this.
Hope this helps
Norman
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 1:51 PM
To: CF-Talk
Subject: OT: SQL VS ACCESS
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
