• You are not logged in. | Login

Post a reply

  • Index
  •  » Help me!
  •  » Please help to optimize the query to the database, server is down

January 23, 2007 11:01 am

reetesh
Member
Ranks

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
Ranks

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
Ranks

Re: Please help to optimize the query to the database, server is down

Thank u for advise


 

 
  • Index
  •  » Help me!
  •  » Please help to optimize the query to the database, server is down
  • Actions
  • Top
ITCrimea. Ukraine Web Development Company. Professional Developers and Web Designers Team
Custom Web Designs, Internet Applications, E-Commerce Websites, Interactive Sites, Database-Driven Sites and Services