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