[SqueakDBX] Re: [opendbx] Mssql connection failed

[Mariano Martinez Peck]

On Thu, May 12, 2011 at 1:21 PM, Alain rastoul <Alr.dev at free.fr> wrote:

> 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 !
>
>
Well, these are great news!!! :)
Please, if there is something we can improve in the documentation of the
website, let us know.



> 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 tha



Did you see the benchmarks we have ? Check the classes DBXBigBenchmarks,
DBXTinyBenchmarks and DBXMultipleForksBenchmarks.
And this link:
http://www.squeakdbx.org/Benchmarks


> nt
> MSSQL-freetds backend (needs explorations here)
> - perhaps a problem with TinyInt datatype ?
>  (not very important)
>


Probably related to:

http://www.squeakdbx.org/Mappings%20from%20String%20to%20specific%20squeak%20types%20in%20selects#Whathappenifyouareretrievingarowthathasanotsupportedfield

http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes

Cheers


> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>



-- 
Mariano
http://marianopeck.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110512/e55d8c14/attachment.htm