On 6/12/01, Bruce, Rodney penned:
>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?
Not a SQL guru by any means, but where is the SQL server? Is it a
development box or the live server? Some hosts have hundreds and
hundreds of SQL databases and if the box isn't up to snuff, it will
probably be slow.
Most SQL Servers are also on a separate box. Where CF can usually
query an Access database right there on the box, it usually has to
traverse some switches, etc., to get to the SQL Server box, then of
course the data has to be returned.
Also, if you use the DTS to import your data and create a new
database, you'll lose your indexes. Searching is much faster on
indexed fields.
I haven't noticed any extreme speed gains using SQL Server, but most
of the sites I work on aren't high traffic. Put 50 people accessing
it at once and THEN see what happens against Access. :) Your data
will also be safer, integrity-wise. There are alot of advantages
other than speed. Automatic backup scheduling, etc.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
