The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
Does it take longer to render the Frontpage the more Videos a Site has ?
If yes: is it possible NOT to make an database query to count all the videos?
I know it is needed for the pagination on the bottom.
BUT: What if you show only the newst videos. Yes true, i want to question if it is needed to count ALL videos.
Scenario:
A user visits the site:
All new videos are shown. Nice.
He wants to see for example: Assfucked Blonde.
He types it into the search and finds it.
___PERIOD___
My Question is: Is it needed to query the Database for ALL Videos?
I ask that NOT because AVP has a bad performance ( it is lightyears before ALL other Scripts), but i think how to make the performance better as it is already.
All that questions are grounded on the believe that queriing the Database for the Pageing is an performance hole.
BTW: i know, my english is like a peace of shit but i hope you understand, what i want to say
Last edited by Coscast (2011-03-04 00:39:51)
Offline
I understand exactly what you want to say and you are right the query for the pagination is slow, and there are no solutions for this (except video_id > some number, but this will not work after you delete a lot of videos). There are a lot of articles on the internet that explain exactly what you said above, as a solution for the pagination problem.
If you want you could remove pagination from the frontpage.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Just thaught about this again, and if you use a recent version of MySQL with MyISAM (i will modify the database structures, some tables will use InnoDB), then the pagination query is lighting fast because it uses keys and it also uses (in most of the cases) COUNT(*) which in mysql its optimized.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
COUNT(video_id) for example is slower than COUNT(*).
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1