Click here to Skip to main content
15,887,262 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
we have a table of 50k items and we display it at search page with random sort and 10 items per page , and there is some filters
random with/without seed is very slow
note that items are 3 category and first category should be display first with random order , then the second category with random order also

- generate random number between 0 and max id will is not working because of pages and the previous constrains
- randomize the records with php make items always display at the same page

any better solution to speed up search?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900