Alain,, don't get my wrong.
Im searching for perfomance and good configuration too..
i have severals limitations in english, and that makes me wrong.
thank for share our experience, all learn to these mails.
Saludos
On Thu, May 12, 2011 at 4:55 PM, Alain_Rastoul <alr....@free.fr> wrote:
> Hi Diogenes,
> You are right about cursors in odbc (client or server cursors), but they
> are
> controlled by the application and here there is no cursor. I had a look at
> the ODBC log trace there was no cursor option positioning either (
> SQLSetStmtAttr ). My server is 2005 SP2+ security fix (9.00.3080.00).
> I'm not a fan of ODBC, but with Windows and MSSQL at least it rocks (avoid
> any ODBC specific syntax commands), on the other side having access to SQL
> Server from Unix is really a plus and I would'nt dismiss FREETDS on the
> contrary - I don't know about ODBC on Linux.
>
> About this test, it is not a "real" test, but repeating the same query will
> make all data and plans in cache on the server side and that's perfect here
> because I want to see connection performance , not sql performance. What I
> suspect here is a connection / deconnection overhead, perhaps I should not
> disconnect between queries in the loop.
> It would be interesting to make a real test - I've thought sometimes about
> a
> tpcc like benchmark - could be interesting in Pharo even Glorp.
>
> Cheers
> Alain
>
>
>
>
>
> ------------------------------------------------------------------------------
> Achieve unprecedented app performance and reliability
> What every C/C++ and Fortran developer should know.
> Learn how Intel has extended the reach of its next-generation tools
> to help boost performance applications - inlcuding clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> libopendbx-devel mailing list
> libopendbx-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
