Adult Script Pro Community Forums
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.
- Topics: Active | Unanswered
Pages: 1
#1 2011-11-16 11:40:24
[INPUT NEEDED] Video History
Hi,
The video_history table gets big on sites with a lot of traffic, so the following questions come to my mind:
1. Do any of you use the simple statistics about videos views in Admin -> Dashboard?
2. Do any of you think User -> Dashboard -> Recommended Videos is good?
3. How about if we keep statistics only for a day and then use a summary? (Admin -> Video -> Manage -> View -> Views wont work anymore)
Please let me know what you think! :-) About these questions...if you want to discuss about anything else please use the Open Discussion forum :PPPPP
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#2 2011-11-16 12:41:56
- Eri
- Member
- Registered: 2011-03-18
- Posts: 977
Re: [INPUT NEEDED] Video History
1. i do not use it
2. Recommended Videos is good to make user to sing up
3. having video history for a day will make recommended videos work.
Having a cron to delete video history older than a day will make it work. 
Offline
#3 2011-11-16 13:15:33
Re: [INPUT NEEDED] Video History
Yes. This is how i was thinking also. Anyone else?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#4 2011-11-16 16:43:48
- jaydenblair@live.co.uk
- Member
- From: United Kingdom
- Registered: 2011-10-30
- Posts: 369
- Website
Offline
#5 2011-11-29 15:57:08
Re: [INPUT NEEDED] Video History
I'm thinking that before deleting the video video views from "yesterday" i can just count them and then save in a new video_stats table (width day, month, year and total views). Do you think this is a good idea...or we should just delete the views, without saving any data?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#7 2011-12-01 14:41:36
Re: [INPUT NEEDED] Video History
Yeah...but i'm thinking that a few small stats would be good and i can get them without any database load. The video_history table will still be used, but the table will be cleaned every day (or 2 days, so basically only 2 days of entries will be kept, no recommended videos for users that didnt login in the past 2 days) and a new table video_stats (or something similar), that will keep count of each days video views (summary) and unique views.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#8 2011-12-01 14:46:01
Re: [INPUT NEEDED] Video History
Everything that saves resources without losing the quality of the front end is very welcome 
Offline
#9 2011-12-01 14:52:48
Re: [INPUT NEEDED] Video History
Yeah...its only about the statistics in the backend....frontend is not modified.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#10 2011-12-11 08:48:30
Re: [INPUT NEEDED] Video History
I removed the video view statistics completly. Modified the video_history table and via cron only video_views for 7 days will be kept.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#11 2012-01-01 18:59:46
- ful2fun.com
- Member
- From: Usa
- Registered: 2011-09-16
- Posts: 1,048
- Website
Re: [INPUT NEEDED] Video History
Top Viewed Video Make User To View The Video And If It Is Small Site Then Stats Will be Small .It Should Store Stats And Add It Up For Weeks Etc To Reduce Resources. Views After 7 Days Will Removed Then views Will Reduce To Video.
Offline
#12 2012-02-02 15:11:29
- ful2fun.com
- Member
- From: Usa
- Registered: 2011-09-16
- Posts: 1,048
- Website
Re: [INPUT NEEDED] Video History
Can We Make View History Less Means Like Simply Table That Count View History Like For 45000 Videos It Having More Then 200000 Queries. Can we Make Table Like Whenever Person Hit Video It Just Increase One Hit like from 278 To 279. Like Video Id And Count No. Table Only Not Big History for Month,Day,Week Etc.
Offline
#13 2012-02-04 08:29:45
Re: [INPUT NEEDED] Video History
I will add a cron to count all hits and organize in unique / day, total / day and so on. Stats older than 7 days will be deleted.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#14 2012-02-04 18:48:44
- ful2fun.com
- Member
- From: Usa
- Registered: 2011-09-16
- Posts: 1,048
- Website
Re: [INPUT NEEDED] Video History
I will add a cron to count all hits and organize in unique / day, total / day and so on. Stats older than 7 days will be deleted.
I Do Not Want to Delete 7 Days Older Count Means I Want to Count All Hits But Without Getting Database Heavy By Just Saving Counting of Hits Not The Other Things Like Unique Ip Or Days Hit Or Week It Will Make Database Heavy Or We Can Save Them in Some txt Or csv File To reduce Database load.
Offline
Pages: 1