<br><br><div class="gmail_quote">On Thu, May 12, 2011 at 1:21 PM, Alain rastoul <span dir="ltr"><<a href="mailto:Alr.dev@free.fr" target="_blank">Alr.dev@free.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
I finally got openDbx working with FreeTDS and ODBC, I don't know<br>
what went wrong last night, I suppose my computer got tired ;)<br>
This is great !<br>
<br></blockquote><div><br>Well, these are great news!!! :) <br>Please, if there is something we can improve in the documentation of the website, let us know. <br><br> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
However, I found<br>
- a much better performance with ODBC backend (DBXOdbcPlatform) in<br>
the test I did than with Freetds (DBXMSSQLPlatform) (run the test<br>
below, changing DBXOdbcPlatform to DBXMSSQLPlatform).<br>
With the ODBC backend the test ran about 2 times faster tha</blockquote><div><br><br>Did you see the benchmarks we have ? Check the classes DBXBigBenchmarks, DBXTinyBenchmarks and DBXMultipleForksBenchmarks.<br>And this link: <br>
<a href="http://www.squeakdbx.org/Benchmarks">http://www.squeakdbx.org/Benchmarks</a><br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
nt<br>
MSSQL-freetds backend (needs explorations here)<br>
- perhaps a problem with TinyInt datatype ?<br>
(not very important)<br></blockquote><div><br><br>Probably related to:<br><br><a href="http://www.squeakdbx.org/Mappings%20from%20String%20to%20specific%20squeak%20types%20in%20selects#Whathappenifyouareretrievingarowthathasanotsupportedfield">http://www.squeakdbx.org/Mappings%20from%20String%20to%20specific%20squeak%20types%20in%20selects#Whathappenifyouareretrievingarowthathasanotsupportedfield</a><br>
<br><a href="http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes">http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes</a> <br><br>Cheers<br><br></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<br>
The test below consist read the column definitions of syscolumns and<br>
does not need any other database than master.<br>
Set myhost, myport, mydb, myuser and mypassword as appropriate.<br>
If you uncomment c.xprec, you will have the TinyInt error<br>
<br>
500 timesRepeat: [<br>
| conn connectionSettings result sql |<br>
<br>
sql := 'select <a href="http://c.name" target="_blank">c.name</a>, <a href="http://c.id" target="_blank">c.id</a>, <a href="http://s.name" target="_blank">s.name</a> , c.length --, c.xprec --,<br>
c.xscale, c.xtype<br>
from master..sysobjects as o<br>
inner join master..syscolumns as c<br>
on <a href="http://o.id" target="_blank">o.id</a> = <a href="http://c.id" target="_blank">c.id</a><br>
inner join master..systypes as s<br>
on c.xtype = s.xtype<br>
where <a href="http://o.name" target="_blank">o.name</a> = ''syscolumns'''.<br>
connectionSettings := DBXConnectionSettings<br>
host: 'myhost'<br>
port: '1884'<br>
database: 'mydb'<br>
userName: 'myuser'<br>
userPassword: 'mypassword'.<br>
[ conn := DBXConnection platform: DBXOdbcPlatform new settings:<br>
connectionSettings.<br>
conn connect.<br>
conn open.<br>
result := conn execute: sql.<br>
result rowsDo: [ :r |<br>
1 to: result columnCount do: [:c|<br>
| v |<br>
v := r rawValueAt: c.]].<br>
] ensure: [ conn close ]].<br>
<br>
Cheers,<br>
Alain<br>
<br>
--<br>
<font color="#888888">Alain_rastoul<br>
</font><div><div></div><div><br>
<br>
------------------------------------------------------------------------------<br>
Achieve unprecedented app performance and reliability<br>
What every C/C++ and Fortran developer should know.<br>
Learn how Intel has extended the reach of its next-generation tools<br>
to help boost performance applications - inlcuding clusters.<br>
<a href="http://p.sf.net/sfu/intel-dev2devmay" target="_blank">http://p.sf.net/sfu/intel-dev2devmay</a><br>
_______________________________________________<br>
libopendbx-devel mailing list<br>
<a href="mailto:libopendbx-devel@lists.sourceforge.net" target="_blank">libopendbx-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/libopendbx-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/libopendbx-devel</a><br>
<a href="http://www.linuxnetworks.de/doc/index.php/OpenDBX" target="_blank">http://www.linuxnetworks.de/doc/index.php/OpenDBX</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Mariano<br><a href="http://marianopeck.wordpress.com" target="_blank">http://marianopeck.wordpress.com</a><br><br>