From: Joe W. <jo...@gm...> - 2011-06-15 19:02:45
|
Wolfgang and Benoit, These are very impressive results! Could you explain what kinds of queries / scenarios will benefit from this optimization? I wasn't clear from reading the thread what kind of bottleneck. All I could tell is that queries that imported a chain of modules were slow. Also, do you have any general tips or approaches that you could share about your use of the exist:timer pragma, e.g. (# exist:timer #) {....}? Do you insert this around each expression you want to test, one at a time? I haven't used this pragma before - but it seems like it might have certain advantages over the approach described at http://en.wikibooks.org/wiki/XQuery/Timing_a_Query. Thanks, Joe On Wed, Jun 15, 2011 at 1:23 PM, <ben...@en...> wrote: > Hi Wolfgang, > > It works! > > I finally finished re-import my data (the java client importing does not work very well with this version ...). > > I've done some "very promising" tests: > - With the query cache enabled, and with a single function call: > - First call: 2.72s (5.84s before correction) > - Next calls: 734ms (1s before correction) > > - With the query cache enabled, with a single function call but with 5 never called functions: > - First call: 2.72s (7.65s before correction) > - Appeals to: 766ms (5.61s before correction) > > > Thank you for your work and your efficiency, my application is much more responsive now and I will continue to optimize my code (there remain some util:eval () I have to remove). > > Benoit > > -----Message d'origine----- > De : Wolfgang Meier [mailto:wol...@ex...] > Envoyé : mardi 14 juin 2011 16:10 > À : VINCENT Benoit > Cc : exi...@li... > Objet : Re: [Exist-open] Xquery performance problem > > Hi Benoit, > > resetState was following every function call, so the same function got > reset many times. It think this is what caused your performance issue. > Rev 14693 should fix the problem. Could you retest please? > > Wolfgang > > http://exist.svn.sourceforge.net/exist/?rev=14693&view=rev > ------------------------------------------------------------------------------ > EditLive Enterprise is the world's most technically advanced content > authoring tool. Experience the power of Track Changes, Inline Image > Editing and ensure content is compliant with Accessibility Checking. > http://p.sf.net/sfu/ephox-dev2dev > _______________________________________________ > Exist-open mailing list > Exi...@li... > https://lists.sourceforge.net/lists/listinfo/exist-open > |