Re: Table grows much faster than others.
Dan Nelson <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows,gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
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 Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]