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.
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@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
------------------------------------------------------------------------------
------------------------------------------------------------------------------
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
