PHP | pagination | DB
PHP | pagination | DB
Out of context: Reply #4
- Started
- Last post
- 5 Responses
- UndoUndo0
the more items (rows) that are returned from the db will mean the longer it takes the code to process the script, if the code has to sort through all of them instead of just fetching a handful then it will slow down as the database gets bigger.
it also depends on how yr db is designed(optimised) and whether your searches are on indexes or in Boolean mode.
if you are searching on idexes these will need to be re-created as more info is added to keep the db performing well. that probably means nothing to you but should mean more to yr developer.
the http://dev.mysql.com/ website has lots of info on how to optimise