Hello All

I have recently created a php base report that doe several hits on multiple databases and multiple table in those databases using data that is user provided. My problem is that my query's keep putting locks on my database which cause the queries to run significantly slower causing my server to time out.

Any suggestions?


_________________
Jayce Obrigewitsch
IS Support Tech/Web Programmer

perform queries on ids instead of text fields

because int searched fast than a text


_________________
HaRoOn
haroon373@gmail.com
+923216638785
http://www.phpmetablog.com

First of all think about your infrastructure. Do you really need multiple databases?

Second of all, normalize the tables and use integer indexes and integer foreign keys to reference table relationships.

You can also try minimizing the columns you select. Instead of doing SELECT *, take a bit of time to write in just the columns you'll actually use.

Thanks for the reply's.
   The problem is that it is a report that has a lot of information in it. And the company infrastructure is already to large to start consolidating databases into 1.
    I don't use any SELECT * so that is not the issue.
    I think maybe the 1st thing to try is to check to make sure my queries are all done on indexes and also make sure my tables have indexes.

Thanks Again


_________________
Jayce Obrigewitsch
IS Support Tech/Web Programmer

Are you using fulltext search by any chance?