Technical Performance Question

Coscast · 2011-03-04 00:37:03

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)

symtab · 2011-03-04 07:56:09

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.

symtab · 2011-03-09 10:26:52

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.

symtab · 2011-03-09 10:27:10

COUNT(video_id) for example is slower than COUNT(*).

Adult Script Pro Community Forums

#1 2011-03-04 00:37:03

Technical Performance Question

#2 2011-03-04 07:56:09

Re: Technical Performance Question

#3 2011-03-09 10:26:52

Re: Technical Performance Question

#4 2011-03-09 10:27:10

Re: Technical Performance Question

Board footer