4 messages in com.mysql.lists.javaRE: Mysql table size| From | Sent On | Attachments |
|---|---|---|
| Andras Balogh | 31 Aug 2000 02:40 | |
| Uwe Schuerkamp | 31 Aug 2000 02:40 | |
| Andras Balogh | 31 Aug 2000 02:49 | |
| John Raab | 31 Aug 2000 10:22 |
| Subject: | RE: Mysql table size |
|---|---|
| From: | John Raab (jra...@affinity.net) |
| Date: | 08/31/2000 10:22:48 AM |
| List: | com.mysql.lists.java |
I think table size does affect lookup speed. Our mysql DBA seemed to think so...
Its easy to check. Just create a new table with 100 records, do a lookup on that, and then do a lookup on your 500,000 record table and compare the time each query took.
-John
-----Original Message----- From: java-return-1531-jraab=affi...@lists.mysql.com [mailto:java-return-1531-jraab=affi...@lists.mysql.com]On Behalf Of Andras Balogh Sent: Thursday, August 31, 2000 2:41 AM To: ja...@lists.mysql.com Subject: Mysql table size
Hi all,
I have a mysql table containing 574948 rows. In this table we store the data about the visitors of our sites. I have a servlet that presents this data in a nice way. I have noticed that it is working slower and slower. I want to move all the old data (3 months old) in an another table. I want to ask if this would speed up the queries or no. Can anybody say how the data is stored by mysql? Should i move this old table in another database too?? Thank you, Andras.