Menu
▾
▴
[Exist-open] Query performance and "OR" operator
|
From: <sp...@so...> - 2004-05-13 08:41:37
|
Hi all =20 I repost my message from the 2004-04-29. No answer has been posted. This problem is very annoying, because I can=92t execute a query with = multiple =93or=94 statements to select several documents in a collection. =20 I'm using the last CVS snapshot (2004-05-10) on Windows XP, and I'm experiencing performance issues when querying eXist with some of my = X-Path or X-Query queries. The X-Path or the X-Query must contain several 'or' boolean expression ; = you don't need to have different expression in it (see example).=20 If you execute it, the CPU runs 100% for a while (1 or 2 minutes, = depending the amount of 'or' operands you wrote), and finally you get the = resultset. =20 The snapshot from the 2004-04-27 shows the same behaviour. =20 To reproduce this problem, use an empty eXist database, insert the = following XML sample document and use the given query (in the Java Client or with = the Java API) : =20 Sample XML doc : =20 <test @myID=3D'00001'>content</test> =20 Query :=20 =20 /test [@myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or = @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001' = or @myID=3D'00001' or @myID=3D'00001' or @myID=3D'00001'] =20 Is this a bug ? Is there any trick to bypass this problem ? =20 Regards, =20 Sebastien Pousse =20 |