NEW UD 4.5 (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Martin Drenovac, Bob Carten, Pascal Landry, Ray Chan

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 05 JUL 2008 02:38:19AM Martin Drenovac wrote:

I'm very excited to read in the Uni Driver 4.5 Upgrade Manual the following:

In the Technical Details section

"designed to reduce network traffic and increase application speed by processing Linear Hash file activity on the server".

What are the chances of an elaboration on these comments and what they mean - do we finally have server side selects?

Cheers

At 07 JUL 2008 05:55AM Bob Carten wrote:

do we finally have server side selects?

Not through the UD. The availability of calculated columns means selects in OpenInsight can exploit the full power of the engine, so they need to be processed through an engine. In effect, The OEngine functionas as the middleware business layer that is now standard in other environments.

I did post an example (to you, I think) of executing selects on the server, returning the keys of the selected records. See This thread

I believe that one optimization in the UD is that the read operation passes back the record, rather than the frame(s) containing the record. In other words, if you know the key you get the record. Thus, if you use an oengine on the server to get the list of keys, then the actual reading of the records for processing will be very efficient.

At that point you will be behaving like an SQL client server application with Client-Side cursors.

hth

- Bob

At 07 JUL 2008 06:56AM Martin Drenovac wrote:

Cheers Bob. Yes, you did send me the code.

I am on the path of exploring keeping my indices in SQL and the SQL doing exactly as you've spoken in your demo. We've had too much pain with index rebuilds on 1 million row tables.

Have you looked at the SQL MFS code I forwarded to Mike? I personaly have no interest in U2, our hybrid adaptation is SQL / OI.

At 14 JUL 2008 08:58AM Pascal Landry wrote:

Kudos Revelation, WAN speed has significantly increased with UD4.5. Things seem to be zipping quite a bit more since I installed it an hour ago.

No empirical test were performed for this endorsement. All views mentioned are purely the views of the operator without any remuneration from any parties.