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
