Archive for August, 2011

Array Binding and Array Fetching in ODBC Connects

Yuwei Li recently wrote:

Some databases and their ODBC drivers allow clients to control the number of rows that will be physically transferred between the server and the client in one logical bind or fetch. These features are called array binding and array fetching. Using array binding and array fetching can greatly improve the performance of many applications by trading buffer space for time (network traffic).

From Cincom® ObjectStudio® 8.4 and Cincom® VisualWorks® 7.9, Cincom starts to support array binding and array fetching in ODBC connects.

Software developers are lucky people. There are many different application development environments available to choose from these days. Lots of them are well suited to getting work done quickly—if your database and object design can follow their simple rules.

On the other hand, software developers are often not that lucky in their projects. Out of all the projects they’ve worked on, how many were pure “green field” development, where they had full control over all aspects of their database and object model? How many had to connect new processes or requirements to existing data stores whose schemas could not be changed or were ill-documented (or both), or else had to interface with a DBA group who had their own rules about naming? This is a situation where Smalltalk can really shine.