[PHP-DB] Need Help in Mysql database

2010-06-30 Thread nagendra prasad
Hi All,

I have a huge set of MP3 database. My problem is that when I try to search
in my database its getting very slow. I was wondering if I split that
database into 2 or more tables. Will this improve the speed of searching? Is
it the best solution for my problem or is their any other solution?

Best,
Guru.


Re: [PHP-DB] Need Help in Mysql database

2010-06-30 Thread Bastien Koert
On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad
nagendra802...@gmail.com wrote:
 Hi All,

 I have a huge set of MP3 database. My problem is that when I try to search
 in my database its getting very slow. I was wondering if I split that
 database into 2 or more tables. Will this improve the speed of searching? Is
 it the best solution for my problem or is their any other solution?

 Best,
 Guru.


What are you :

a) searching on
b) have mysql indeces on


Also have you run an explain plan on the query to see if its using any indexes?

-- 

Bastien

Cat, the other other white meat

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php