By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,661 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,661 IT Pros & Developers. It's quick & easy.

size of a file depending of number of queries or tables

P: n/a
Hi all,

i would like to know what can make the file to be bigger sized,is it
becouse of the queries or becaouse of the tables?

Jun 7 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Hi

Everything in a database will add to it's size. Queries do not store
data so will not take up much space but naturally they store the SQL
query and various properties. Tables store data and depending on what
that data is and how much of it there is will affect the db size.

James

On 7 Jun, 16:17, thread <yaniv...@gmail.comwrote:
Hi all,

i would like to know what can make the file to be bigger sized,is it
becouse of the queries or becaouse of the tables?

Jun 7 '07 #2

P: n/a
Hi.
i would like to know what can make the file to be bigger sized,is it
becouse of the queries or becaouse of the tables?
It's the tables, which hold the data, that can increase the file size
rapidly. Queries only increase the file size by the number of bytes the
text in the query requires when it's stored in the MSysQueries table and a
little database overhead for pointers to that data page.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
Jun 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.