Hmm Bruce... What sort of configuration are running on the SQL box??? I initially noticed the same thing myself when starting with SQL... the example you give is single threaded, SQL Server shows off when running multiple sessions simultaneously... Big things to look at: Multiple processors, memory... I still use Access to do most things and put final systems out on SQL server where appropriate (mainly where lots of data will be collected or lots of different data is going to be pulled from the database at the same time by different people)... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -----Original Message----- From: "Bruce, Rodney" <[EMAIL PROTECTED]> Date: Tue, 12 Jun 2001 10:51:09 -0700 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
