On Wed, Jan 7, 2009 at 9:04 PM, Stancescu, Bogdan <bogdan(a)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.