PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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...
> 
> Michael

	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. 

8-)