On Thu, Nov 20, 2014 at 11:37 AM, Gene Wirchenko <[email protected]> wrote:
> CREATE CURSOR fred (myresult c(10), therecno I) >> > FOR I = 1 TO 110000 >> INSERT INTO fred values( "data", 0) >> NEXT >> >> REPLACE ALL therecno WITH RECNO() IN fred >> >> Subsecond result, on an old Core2 processor with 4 Gb RAM. >> > > Point on that. With a cursor, it was under a second with the table > data I tried yesterday. > > My point about large amounts of data still stands though. If it were > a 2 GB cursor, the results would be rather different on my 1.5 GB RAM > system. > --------------------- You do not have to put a value in for recno() so why waste resources? Recno() is apart of the system just like deleted(). Notice the () for a function that is generating the value for you. Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYKLydrZNvU9B2w1uo=ztrvz4bnctxkrt9phlvgv__n...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
