Re: [ADMIN] what is the impact of Database size on Performemce

2004-04-05 Thread HumanJHawkins
Avner [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I need some information to understand what is the impact of Database size on the performemce. CUT 1. Is there any impact? In queries that make use of the data, yes. 2. Does one very large table impact the performence of the the

Re: [ADMIN] what is the impact of Database size on Performemce

2004-04-05 Thread Erland Sommarskog
Avner ([EMAIL PROTECTED]) writes: I need some information to understand what is the impact of Database size on the performemce. Few questions : 1. Is there any impact? Maybe. Maybe not. Depends whether you query the large table, and not the least how you query them, and what indexes you

[ADMIN] what is the impact of Database size on Performemce

2004-04-05 Thread Avner
I need some information to understand what is the impact of Database size on the performemce. Few questions : 1. Is there any impact? 2. Does one very large table impact the performence of the the whole DB, meaning the overall performence and access the other tables. 3. What are the ways to

Re: [ADMIN] what is the impact of Database size on Performemce

2004-04-05 Thread louis nguyen
1. Is there any impact? 2. Does one very large table impact the performence of the the whole DB, meaning the overall performence and access the other tables. 3. What are the ways to reduce the impact of the DB size on the DB performence I've run into 2 problems w/ very large DB. A)