…,00,000 user records, I have Problems with Login, which is very slow (Terribly Slow), All i have is PHP / MYSQL with a… MySQL is Just around 650 MB. What iam using to login check with this simple query “SELECT useremail,password FROM USERS…
Comment: MySQL Query Cache
November 17, 2009 By 70 Comments
… AS Visit__consultant, Vist.student AS Visit__student, Visit.login_time AS Visit__login_time, Student.id AS Student__id, Student.firstname…, ‘Student__’); $consultant->map_fields($row, ‘Consultant__’); Obviously, it’s still slow comparing to memcache (if you cache all the objects) as…
Comment: Working with large data sets in MySQL
July 17, 2007 By 12 Comments
… returning a long list of users, sorted by their last login times? I’m using paging (limit) in my mysql, but…. Without the sorting things are fast, but with sorting, it slows down to a crawl, especially at the last pages. What…
