Primary Keys, Multiple Index and Searching

es MySQL (currently 4.0.14, although it'll be running on 3.23.53 eventually) allow the searching of multiple indexes, or is it better to specify multiple indexes with similar columns to maximize performance? Thanks, -- jonathan wright // mail at djnauk.co.uk // running on gentoo linux // life has n

Re: Primary Keys, Multiple Index and Searching

udied), and I'm interested to know how the query is optimized given a multiple column searches and possible multiple indexes. :) -- Jonathan Wright Life has no meaning unless we can enjoy what we've been given -- Running on Gentoo Linux (2.6.10-gentoo-r7-djnauk-b03 i686 AMD At

Re: How does a multi-row INSERT work?

y but according to the manual, a multi-row INSERT is faster. I think you're looking for something like INSERT INTO table [ (x, y, z) ] VALUES (a, b, c), (d, e, f), (h, i, j); -- Jonathan Wright Life has no meaning

Re: The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

7; in order to work. Otherwise set $cfg['PmaAbsoluteUri_DisableWarning'] = TRUE; In order to disable the warnings. -- Jonathan Wright Life has no meaning unless we can enjoy what we've been given -- Running on Gentoo Linux (2.6.10-gentoo-r7-djnauk-b03 i686 AMD Athlon(tm) XP 2100+ GNU