Up Prev Next
From: Steven Cruz <steve at nextopia dot com>
Subject: Re: Cursors and overhead!!!!!!!!!!!!!!!!!!!111
Date: Aug 31 1999 3:38PM
Michael Peppler wrote:
> > You could also take all your results dump it into a temp file and read
> > from that. It would save repeated database hits.
> But you'd have to seek the temp file instead, which may or may not be
> faster depending on the size of the temp file...
True, But if you only have 1000, records then you should be able to
load the file to an array and index it like that. Of course their are
other problems such as how to maintain files. (how long to keep, how to
name them for quick access) The files idea works if you have allot
people sharing the same amount of small static data.