session lock problem

@makif,

This may be an issue of the queries running to long which is causing the PHP session to lock.  This points to a database issue.  Have you tested your queries to see how long it takes for them to execute?  Have you tried the turning on the Profiler to see what queries have been run and how long they are taking?

yes i did test and control profile, for example i have datas for 2 years and table has about 120-150 millions rows. User search without giving date and query takes long.  it takes ten minute, sometimes it takes more than ten minutes,  also i use joins, order by desc and limit