Database Discussion - Access and SQL

Print Page | Close Window

Access and SQL

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15587
Printed Date: 28 March 2026 at 3:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access and SQL

Posted By: bootcom
Subject: Access and SQL
Date Posted: 25 June 2005 at 6:26am

Quick question ...

If an access database has onwards and upwards of 100000 records and your just pulling the top 10 records out everytime, would this have as much impact as pulling the top 10 records with 1 with 500 records. Silly question yes. But im needing to introduce some extra performance stuff to my chat and am trying to save valuable time where poss.

Replies:

Posted By: ljamal
Date Posted: 26 June 2005 at 10:31pm

The full Access database is loaded into memory every time you access it. The smaller the database the batter performance would be.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming