Heyho folks,
I hope I am in the correct mailing list here.
We do have a performance problem with mySQL.
In the database we have :
INSERT INTO art_xml VALUES ('0', '<article-info><pn lang="en">english
product nr 0 </pn><pd lang="en">and went away, and two technicians remained
with instrument and started to\r and </pd><pn lang="de">deutsches product
nr 0 </pn><pd lang="de">and protected meaning of civil life.\r and
</pd></article-info>');
lots of these entries...
and querying happens with :
SELECT pr.*, SUBSTRING(xml_description, LOCATE('', xml_description) +
length('') ) as jezus FROM art_xml as pr WHERE pr.xml_description regexp
'<[[:space:]]*pn[[:space:]]*lang="de"[[:space:]]*>[[:alnum:][:space:]]*de[[:
alnum:][:space:]]*<' ORDER BY jezus
Well this works.. but.. it is f***cking slow... really slow.. serious
slow...
( 50,000 entries need much more than 3 minutes to process this select)
So the question is - do we make a major mistake here or is it just so slow ?
Thnx folks :)
dodger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
