I just tried on the Toolserver to get the latest ten uploaded SVGs:
SELECT img_name, img_user_text FROM image WHERE img_minor_mime = 'svg'
ORDER BY img_timestamp DESC LIMIT 10;
Takes between 0.00 and 0.02 secs. I don't know how this is comparable
with the "real" databases?
Bryan
On 4/5/07, Simetrical <Simetrical+wikilist(a)gmail.com> wrote:
On 4/5/07, Bryan Tong Minh
<bryan.tongminh(a)gmail.com> wrote:
How about a search that searches on the
mimetype? Would that also be slow?
Currently, yes, but potentially, no. An index would have to be added.
Then it would be very fast.
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/wikitech-l