On 5/5/06 6:33 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution