On Thu, May 12, 2011 at 10:24 PM, Alain_Rastoul <alr....@free.fr> wrote:
> Hi Mariano,
>
> Thanks for the pointers, I'll have a look at those links and tests.
> I think there are lot of developpers using windows and MS technology and
> that it would be nice to document a litle bit more this configuration
> specifically - I remember several posts on squeaks mailing lists about sql
> server connection with squeak - prehaps having precompiled binaries would
> help a lot too - Your docs on the build are nice, but not all developpers
> feel comfortable with that boring stuff.
>
>
Hi Alain. There are binaries. This is explained in:
http://www.squeakdbx.org/Compiling%20and%20installing%20OpenDBX
and it links to:
http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Unix-like
http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows
Cheers
Mariano
Regards
> Alain
>
>
> "Mariano Martinez Peck" <marianop...@gmail.com> a écrit dans le message de
> news: BANLkTi=5CM-AXxt=dybhbhqt8uh-5sm...@mail.gmail.com...
>
>
> On Thu, May 12, 2011 at 1:21 PM, Alain rastoul <alr....@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-5nwgofrqmnerv+lv9mx5uipxlwaov...@public.gmane.org
>>
>> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
>> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>>
>
>
>
> --
> Mariano
> http://marianopeck.wordpress.com
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> 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
>
> ------------------------------
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
--
Mariano
http://marianopeck.wordpress.com
------------------------------------------------------------------------------
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
