I want to know if I am doing a list of students, which are executed from database (mysql),

does the number of data influence in the speed of the page load?

if yes:
What to do ?

And for how much data should I start to think for a solution ?

Thank you

5 Years
Discussion Span
Last Post by cmps

The actual number of records being read from the database shouldn't have much impact unless it is really large. If you are displaying a very long list on a web page that will have some impact. The solution to that is to use "pagination" to display a fixed number at a time with navigation button to move forward or backward. There are JQuery modules and sample PHP code available if you do a search on "pagination".


Together with chrishea suggestions you can:
1. cache queries on mysql
2. run tables in memory engine (a copy of the original)
3. cache result to a file or better cache php
4. cache results to memory through memcached

For reference:
1. http://dev.mysql.com/doc/refman/5.1/en/query-cache.html
2. http://dev.mysql.com/doc/refman/5.5/en/memory-storage-engine.html
3. http://php.net/manual/en/book.apc.php
4. http://php.net/manual/en/book.memcached.php

bye :)

Edited by cereal: n/a


I am using the pagination, but the question is even if i use pagination,
in the code there will be

mysql_query('select * from TABLE')


mysql_query('select * from TABLE LIMIT $a,$b')

because first I should count all data and than do a math trick !!

mmm ...

Thank you anyway =)


@cereal I didn't get my answer in these pagse ... sorry
But thank you anyway

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.