I posted this discussion to collect feedback from all of you. In last couple of days, We were having queries of intense background processing of izap_videos plugin. That is something obvious with izap_videos plugin on elgg framework. In case of ON SERVER support, we used elgg objects to track all queue process. And all we know, elgg is lil harsh on mysql, So need more care in this sense.
So what possible solutions now we are coming in the next release of izap_videos plugin, We are going to by pass elgg db and setup sqlite db in background to take care of queue process. This way we just cut down the database load without messing up with elgg database. This is the best way, i think to have all functionality keeping elggish programming.
So please post your feedback about this concept. In few minutes, i am also going to release candidate release of izap_videos 3.5.
You can try https://izapvideos.googlecode.com/svn/trunk/ if you are curious and would like to contribute your feedback :)
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Imoutofhere@durangod
Imoutofhere - 0 likes
- iZAP@izap
iZAP - 0 likes
- iZAP@izap
iZAP - 0 likes
You must log in to post replies.most excellent, this 3.5 still uses elgg db correct ? thanks so much
Yes this will use elgg db. Actual video entities would be saved in the elgg db. The extra overhead of queue has been cut down from elgg db and shifted to sqlite. Easy sql statements to deal with columns instead of thousand of rows. So this would be great move toward optimization. We are working on elgg core to find more feasible solutions to cutdown load from elgg db without messing with elgg db.
sqlite scheme can save lots of resources not for only izap_videos plugin, but for elgg core it self.
I just released this version. Please download from http://community.elgg.org/pg/plugins/izap/read/385079/izap_videos-35-candidate-release-cut-down-background-database-processing
Thanks