On Wed, 11 Oct 2000, Differentiated Software Solutions Pvt. Ltd wrote:
> Hi,
>
> We have an application where we will have to service as high as 50 queries a second.
> We've discovered that most database just cannot keep pace.
>
> The only option we know is to service queries out of flat files.
> Can somebody give us pointers o n what modules are available to create flat file
>based database.
> Specically we want a mechanism to be able service queries which can return rows
>where values are greater than specified value.
> We are experiementing currently with dbm and DB::File. These seem to handle hashes
>quite comfortably. How do we handle these inequality queries.
>
Something you may want to consider if you are doing large numbers of
read-only transactions on the DB, build them into a large complex data
structure and load them, pre-fork, into ram. Store them in a package
variable. It is extremely fast and scalable.
Sean Cook
Systems Analyst
Edutest.com
Phone: 804.673.2253 1.888.335.8378
email: [EMAIL PROTECTED]
__________________________________________________
Save the whales. Collect the whole set.
