[Nepomuk] Review Request: Virtuoso Backend: Optimize ODBC getCharData

Sebastian Trueg sebastian at trueg.de
Mon Sep 17 19:01:09 UTC 2012



> On Sept. 17, 2012, 12:38 p.m., Sebastian Trueg wrote:
> > I suppose 100 is fine in most situations except for long literals which are rarely queried anyway.
> > This looks good. Did tests show that the overall performance improves on the getData call?
> 
> Vishesh Handa wrote:
>     Yup. The Valgrind output showed it taking less time to execute, but this wasn't very scientific.
>     
>     I even went through large parts of the ODBC documentation - We can optimize query result fetching quite a bit. But I want proper benchmarks before I do that. If you want I can wait to push this until I have some more concrete benckmarks.
>     
>

Your call.


- Sebastian


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
http://git.reviewboard.kde.org/r/106467/#review19063
-----------------------------------------------------------


On Sept. 17, 2012, 9:37 a.m., Vishesh Handa wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> http://git.reviewboard.kde.org/r/106467/
> -----------------------------------------------------------
> 
> (Updated Sept. 17, 2012, 9:37 a.m.)
> 
> 
> Review request for Nepomuk, Soprano and Sebastian Trueg.
> 
> 
> Description
> -------
> 
>     Only use 1 SQLFetchData command in most of the cases.
>     
>     Callgrind stats show that 67.5% of the time in this function is spent in
>     the first SQLFetchData, and an additional 27% in the second SQLGetData.
>     We can avoid some of this extra cost, by only calling the function
>     once.
> 
> I can change the size of the default buffer if required.
> 
> 
> Diffs
> -----
> 
>   backends/virtuoso/odbcqueryresult.cpp a4f2387 
> 
> Diff: http://git.reviewboard.kde.org/r/106467/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Vishesh Handa
> 
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/nepomuk/attachments/20120917/4116e1b9/attachment.html>


More information about the Nepomuk mailing list