On Nov 21, 2011 11:27 AM, "Petr Bena" <[email protected]> wrote: > > Sounds cool, but could you explain to me a bit how could that be useful in > this case? Problem is that I actually "need" to have the table updated at > least every 5 minutes or 10, otherwise data whether user is online or not > wouldn't be true. I understand that memcache can be used to temporary store > some values instead of looking them up over and over again, I guess I could > just store there the timestamp and username of each user so that it > wouldn't need to select it from db?
Exactly. > but what about writes to db every 5 > minutes? is this a problem? Probably not; watchlisted page views and editing activity probably already do more. > could it be avoided? also memcache probably > isn't available on every server, although it was primarily developed for > wikimedia projects where it is surely being used, apart of many other > accelerators, I wanted to make the extension rather simple for wide use > even by others who have mediawiki and like it. Thanks Use of memcache-style caching usually degrades gracefully if there's no cache; you just fall through to the DB. -- brion > > On Mon, Nov 21, 2011 at 7:23 PM, Platonides <[email protected]> wrote: > > > On 21/11/11 12:59, Petr Bena wrote: > > > The table is also supposed to be periodicaly cleaned (expired records), > > so > > > it's supposed to be very small. > > > > > > So, does anyone have any suggestion to make it even faster? Ian Baker > > told > > > me that there could be some use of cache, however I am not really sure > > how > > > to implement it, what do you think about this conception, is there any > > way > > > to make it simpler and keep its functionality as it is? > > > > > > I don't know if this is a correct place to ask, I don't know if there is > > > some mediawiki forum where I could ask which would be more suitable. > > > Thanks > > > > Hello Petr :) > > mediawiki-l and wikitech-l are perfect forums for this. > > > > You would use just $wgMemc > > See http://www.mediawiki.org/wiki/Memcached#Using_memcached_in_your_code > > for an example. > > > > > > > > _______________________________________________ > > MediaWiki-l mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
