On Wed, Jan 7, 2009 at 9:04 PM, Stancescu, Bogdan bogdan@moongate.ro 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.