On Wed, Jan 7, 2009 at 9:04 PM, Stancescu, Bogdan <[email protected]> wrote: > As I said, think article names (and by extension page names in general), > or namespaces and usernames for that matter (well, ok, I expect > namespaces are pretty much abstract, but usernames are still relevant).
I don't understand what you're saying. Article names and usernames are varchar(255), namespaces are int, and I expect them to remain that way. What we're discussing is only edit summaries and the like, rev_comment and log_comment and so on (if there is any so on, I can't recall offhand). > I haven't looked this up in the code, but if there's any sanity left in > this world I hope all significantly expensive operations on those fields > are performed by the DBMS (as opposed to PHP caches and the like). In > which case any and all optimization options/alternatives/hacks become > relevant. But we're not talking about those fields. I don't understand the relevance. Obviously, yes, the database queries are optimized, we don't scan tons of rows and filter in PHP. IIRC there are <10 queries per page average with average time of <10 ms per query, depending on how recently Domas has stabbed people. _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
