Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19
How much is too much (SQL)?
Results 1 to 3 of 3

Thread: How much is too much (SQL)?

  1. #1

    How much is too much (SQL)?

    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.
    Code:
    +-------------+--------------+------+-----+---------+----------------+
    | 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

  2. #2
    Mentor
    Join Date
    Jun 2001
    Posts
    1,672

    Re:How much is too much (SQL)?

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

  3. #3

    Re:How much is too much (SQL)?

    Yeah, it will be fine .

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •