MySQL Forums
Forum List  »  Microsoft Access

Re: access vs oracle
Posted by: Sebastien Caisse
Date: March 19, 2006 08:30PM

Access can work fine in single a single user environment with smaller tables however in a multi-user environment (even few users) it can slow down to a crawl. I'va haf a ~5k row query (though it looked into about 100k rows) run down typically to as long as 7 seconds (often worst during high file access times...) with only about 15 users, on a dedicated file server. Though the file server usage did vary, fact is every Access connction made essentially spaws it's own "server" making up queries and this can potientially mean that it needs to read most of the database to figure out the result of the query. This means each connection pretty much downloads the entire table to process it's values every query.

Using a server (wether Oracle, MS SQL or more appropriatly for this forum, MySQL) means it only "downloads" what you queried for.

Above stated queries passed to ~0.05 seconds - and on top of it, it doesn't fluctuate depending on the file server usage.

Options: ReplyQuote


Subject
Views
Written By
Posted
11127
June 10, 2005 12:45AM
6223
March 02, 2006 10:11PM
3940
March 17, 2006 07:12AM
Re: access vs oracle
4317
March 19, 2006 08:30PM
3311
March 20, 2006 08:42AM
3184
March 20, 2006 02:14PM
2855
March 21, 2006 06:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.