How to manage large SQL data sets

[Ruslan Zasukhin]

On 5/5/06 6:33 PM, "mfstuart at cox.net" <mfstuart at cox.net> wrote:

Hi Mark,

> Hi all,
> 
> How do I manage in Studio 2.7.1, large sets of SQL data?
> 
> I have over half a million records in a MySQL table (just name, address, and
> phone number), and plan on building an application in Studio to access this
> data. But so far, I've not been able to get past Studio hanging/freezing when
> applying the following SQL statement: "SELECT * FROM names ORDER BY LastName,
> FirstName".

> With that, I'm assuming Studio is trying to load ALL the data from the
> statement into memory. If that's true, it doesn't seem really possible to
> handle larger record sets.

But what revdb function you use to do this query?

You need 

1) builds cursor/recordset
2) use this cursor to navigate records and load only required info
 
> Am I missing something here, or is there a better way?
> And how should the Transcript be written?



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]