It's all about index's. My current "big" table is a table which currently
has ~500,000 rows. We add around 4000-5000 rows a day. This is simply a
table storing session data for visitors. Because of the large amounts of
inserts, we keep the index's low, have 1 primary and 2 non unique index's
which keeps inserts fast. All the access's of this table are done on the
primary key (users session id) keeping the reading fast also. Just be
clever with your index's and you should be fine.
----- Original Message -----
From: "Bruno Fa�" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 9:42 AM
Subject: What can I do ?
> Hello, I�m Brazilian and a new subscriber of this list.
> (sorry my english)
>
> I�m working with MySql and with a 100.000 rows table, this table is
> growing 300 rows in each day.
> How can I arrange this information to get a good performance of my
> queries (my SELECT�s) ?
>
> We intend to do this:
> Work with 2 databases, put 10.000 in the one that I have 90% of acces,
> and put the rest of rows in the orther.
> Is this a good idea with MySql ?
>
> Or there is a better way to do this ?
>
> Thank You !
> Bruno Fae.
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
