MySQL Forums
Forum List  »  Connector/Node.js

How fast is search in much row xml one value (example: id)
Posted by: taurendilcz
Date: January 29, 2007 08:25AM

Hello, how fast is search in much row xml one value (value example: id or idproduct)?
I want use xml to save id and I am not sure at the speed of query like this(it's only example):
SELECT productname FROM product WHERE EXTRACTVALUE(ids,'/user/id')=5;
I cannot know speed query, when my table 'user' will be full.
I have a good reason's to save id's in xml, but how quickly can be a query in this situation?
Is it a possible?



Edited 1 time(s). Last edit at 02/08/2007 08:54AM by taurendilcz.

Options: ReplyQuote


Subject
Written By
Posted
How fast is search in much row xml one value (example: id)
January 29, 2007 08:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.