I haven't messed with Access in a while [97]. But I remember an analogy that
went something like:
Access is like something going to the library and asking for a book. The guy
at the counter takes the you into the library to find the book. While both of
you are out looking for the book six more customers come in and need a book.
Well, each one has to wait his turn for the librarian to return and then
escort them out to find their respective info.
On the other hand MS-SQL has many librarians at the front desk just waiting
for customers to walk in. When they do ... just one of them escorts their
customer out to find the info. While many other are just sitting at the front
desk twiddling theirs thumbs waiting for the next request.
Well, my guess is that if you benchmark Access against MS-SQL when there is a
large number of concurrent queries ... well you get the picture.
Cheers,
Bill
In a message dated 6/12/01 4:46:46 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> I'm guessing you're running CF and SQL server on a sissy girly box, no
> wonder it's slow. Access don't need as many resources as SQL server, that
> may explain the speed different.
>
> So get rid of your sissy box, and get a monster machine!
>
> I'm running on a 1.3ghz processor and 1.5 gigs of RAM
>
>
> >From: "Bruce, Rodney" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: 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?
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
