Table grows much faster than others.

[Song Ken Vern-E11804]

Hi, 

I have one table which grows at a much faster rate than the rest.
It has 80 times more entries than the second largest table, which has
10k rows.

What are the steps I can take to slow down the growth?
Can I partition the table?
Will the size of the table affect the perfomance of queries?

I am running mysql 4.018 on win2k. 

Please CC replies to me as I'm not subscribed to the list.

Thanks.

--
[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table grows much faster than others.

[Dan Nelson]

In the last episode (Feb 20), Song Ken Vern-E11804 said:
 I have one table which grows at a much faster rate than the rest. It
 has 80 times more entries than the second largest table, which has
 10k rows.
 
 What are the steps I can take to slow down the growth?

The only thing you can do is to insert less records :)  800k rows is a
pretty small table, though, and shouldn't cause you any problems.

 Can I partition the table?

Partitioning will be available in mysql 5.1.  In older mysqls, you can
use VIEWs or MERGE tables and manually migrate older records.

 Will the size of the table affect the perfomance of queries?

It all depends on your queries, of course.  Simple 1-record queries
will slow down at a rate of O(log n), where n=your table size, assuming
you have indexes on everything.

-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]