I'm sorry, but we need a little more information, Such as the query
you're using, the machine type, ram etc., the table structure. With out
those its very hard to help you optimize anything.
Bruno Faé wrote:
>
> 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
