The Artima Developer Community
Sponsored Link

Agile Buzz Forum
VisualWorks Database Driver Weirdness...

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
James Robertson

Posts: 29924
Nickname: jarober61
Registered: Jun, 2003

David Buck, Smalltalker at large
VisualWorks Database Driver Weirdness... Posted: Jul 27, 2006 12:18 AM
Reply to this message Reply

This post originated from an RSS feed registered with Agile Buzz by James Robertson.
Original Post: VisualWorks Database Driver Weirdness...
Feed Title: Michael Lucas-Smith
Feed URL: http://www.michaellucassmith.com/site.atom
Feed Description: Smalltalk and my misinterpretations of life
Latest Agile Buzz Posts
Latest Agile Buzz Posts by James Robertson
Latest Posts From Michael Lucas-Smith

Advertisement

Here's a weird one for ya:

We're running some speed trials on different databases and we've got Oracle 10, Postgresql, SQL Server and Sybase. All was going well, we were using the native drives in VW for Oracle and Postgres and ODBC drivers for Sql Server and Sybase.

Then the weirdness struck. We realised the #execute statement in Postgres was not creating a cursor, it was actually reading all the results in to memory and then giving a Smalltalk stream back on the array! Good god.

So, we were suddenly forced to use the odbc driver for postgres to get proper streaming. This is when we made an amazing discovery. The ODBC driver for Oracle and Postgres were faster than the native drivers.

By native I mean the Smalltalk implementation talking to the native dll's for the database.

Here are the timings off our crap network to our crap database server.

Native Oracle: 2.5s to retrieve 10,000 records

ODBC Oracle: 0.7s to retrieve 10,000 records

ODBC Postgres: 0.5s to retrieve 10,000 records

Wowee.. what's going on here? Are the native drivers written badly in Smalltalk and the ODBC driver written really well or what?

Read: VisualWorks Database Driver Weirdness...

Topic: The Long Tail Bites Previous Topic   Next Topic Topic: Weekly Log Analysis: 7/22/06

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use