
- You are not logged in. | Login
January 23, 2007 11:01 am
- reetesh
- Member


Please help to optimize the query to the database, server is down
Query example:
select id, firm, DATE_FORMAT(date, '%d.%m.%y'), title, reg_id from tbl_prod order by date desc limit 19980, 30
Server shows such an error:
Server shutdown in progress
There 3000 logs in the table.
Approximetly 1500 queries per day
Can "DATE_FORMAT" be the reason of it?
Thank u
Last edited by reetesh (January 23, 2007 11:08 am)
January 23, 2007 11:06 am
- phppat
- Member


Re: Please help to optimize the query to the database, server is down
Can "DATE_FORMAT" be the reason of it?
Of course
There 3000 logs in the table.
Approximetly 1500 queries per day
It is not a lot
limit 19980, 30
That is the reason
PHP monster
January 23, 2007 11:07 am
- reetesh
- Member


Re: Please help to optimize the query to the database, server is down
Thank u for advise


