Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

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

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546
Website

Technical Performance Question

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 smile

Last edited by Coscast (2011-03-04 00:39:51)


sgt-halfsize-banner.jpg

Offline

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,462
Website

Re: Technical Performance Question

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

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,462
Website

Re: Technical Performance Question

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

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

symtab
Administrator
Registered: 2010-08-23
Posts: 7,462
Website

Re: Technical Performance Question

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

Board footer

Powered by FluxBB