database size vs. performance questions
From: <davidsonj_at_gtewd.mtv.gtegsc.com>
Date: 1 Jul 93 15:03:52 -0800
Message-ID: <1993Jul1.150352.615_at_gtewd.mtv.gtegsc.com>
Date: 1 Jul 93 15:03:52 -0800
Message-ID: <1993Jul1.150352.615_at_gtewd.mtv.gtegsc.com>
- How does the size of a table affect performance? (Obviously, the larger the table, the longer it takes to query.) Is there a factor which could be used to translate the response time for a table with 1000 rows versus a table with 100,000 or 1,000,000? Is there a similar effect on insert or update performance? (I did a little test on one table and saw little or no difference between inserts to a table of 1000 rows versus 100,000 rows. Does this jibe with your experiences?)
- Do changes in the overall database size affect the performance of queries (and updates) of a table whose size is unchanged? For example, is the performance different when querying a 1000 row table that is part of a 20MB database versus a 100MB database (assuming all other factors are equal and both databases are populated near capacity)?
I would appreciate any replies and will summarize if there is interest.
Thanks in advance for your help! jimReceived on Fri Jul 02 1993 - 01:03:52 CEST