[thelist] SQL & Access database Speed

[Andrew Clover]

Jess <jslist at sbcglobal.net> wrote:

> I'm working with an Access database and asp.

Don't!

Access (or rather the Jet/MDB backend) is a diddy desktop database, 
don't push your luck trying to use it as a server backend. If you're at 
all concerned about scalability (which apparently you are), it's no use; 
I've even had trouble with it on a simple single-user test box 
(especially with ODBC).

Grab SQL Server, or one of the perfectly good free SQL DBMSs (eg. MySQL).

> I was kind of thinking it was faster if you have 1 giant sql
> statement with 1 adoconn. But would it be faster if I broke it
> down to 4 sql-s and 4 adoconn-s?

You typically won't want four separate connections. As for 4 queries vs. 
1, that entirely depends on what the queries are and the structure 
(schema, indexing) of your database.

-- 
Andrew Clover
mailto:and at doxdesk.com
http://www.doxdesk.com/