Hi alain..
If i remeber well obdc work with a cache and open a cursor to obtein the
resultser. You can check this with the trace tools of mssql server. A good test
may be select with diferent queries, inserts, deletes,updates, etc.. Not
repeating the same query. Please would you send to as you SO and mssql
version.. May be i was wrong and odbc is faster than freetds, with the right
configuration.
Best
D.
Enviado desde mi BlackBerry® de Claro Argentina
-----Original Message-----
From: Alain rastoul <alr....@free.fr>
Date: Thu, 12 May 2011 13:21:23
To: <libopendbx-devel@lists.sourceforge.net>
Reply-To: OpenDBX devel list <libopendbx-devel@lists.sourceforge.net>
Subject: Re: [opendbx] Mssql connection failed
Hi,
I finally got openDbx working with FreeTDS and ODBC, I don't know
what went wrong last night, I suppose my computer got tired ;)
This is great !
However, I found
- a much better performance with ODBC backend (DBXOdbcPlatform) in
the test I did than with Freetds (DBXMSSQLPlatform) (run the test
below, changing DBXOdbcPlatform to DBXMSSQLPlatform).
With the ODBC backend the test ran about 2 times faster thant
MSSQL-freetds backend (needs explorations here)
- perhaps a problem with TinyInt datatype ?
(not very important)
The test below consist read the column definitions of syscolumns and
does not need any other database than master.
Set myhost, myport, mydb, myuser and mypassword as appropriate.
If you uncomment c.xprec, you will have the TinyInt error
500 timesRepeat: [
| conn connectionSettings result sql |
sql := 'select c.name, c.id, s.name , c.length --, c.xprec --,
c.xscale, c.xtype
from master..sysobjects as o
inner join master..syscolumns as c
on o.id = c.id
inner join master..systypes as s
on c.xtype = s.xtype
where o.name = ''syscolumns'''.
connectionSettings := DBXConnectionSettings
host: 'myhost'
port: '1884'
database: 'mydb'
userName: 'myuser'
userPassword: 'mypassword'.
[ conn := DBXConnection platform: DBXOdbcPlatform new settings:
connectionSettings.
conn connect.
conn open.
result := conn execute: sql.
result rowsDo: [ :r |
1 to: result columnCount do: [:c|
| v |
v := r rawValueAt: c.]].
] ensure: [ conn close ]].
Cheers,
Alain
--
Alain_rastoul
------------------------------------------------------------------------------
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
