How much is too much (SQL)?

[gorn]

I have a datbase that is insert'ed to through out the day. it just went live last night and now i have 1200 entries.

these are who logs in to what station where.

+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      |      | PRI | NULL    | auto_increment |
| mac         | varchar(12)  | YES  |     | NULL    |                |
| user        | varchar(128) | YES  |     | NULL    |                |
| login_time  | varchar(10)  | YES  |     | NULL    |                |
| logout_time | varchar(10)  | YES  |     | NULL    |                |
| last_seen   | varchar(10)  | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+

so it's really not a large table. maybe i should change user to take less space.

but anyway the point is, how big can this get before it starts noticiably effecting speed? i think maybe every week i'll put that weeks entries into a different database. then after a month save to a file and delete.

1200*5 = 6,000
this gonna be slow to select from?
the querys are like SELECT * FROM log WHERE mac='foo' LIMIT 10;

thanks

[cloverm]

Just make sure that you index the table on the mac field, then it's going to be plenty fast.

[Ashcrow]

Yeah, it will be fine .