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.
I'd venture to suggest you look back at those RDBMS' again. What were you
using that couldn't handle 50 queries a second? What were your queries
like? How was the database optimised? Was the DB using the right indexes?
Most modern DBMS software should be able to handle 50 queries per second
on decent hardware, provided the conditions are right. You're not going to
get anything better with flat files.
--
<Matt/>
/|| ** Director and CTO **
//|| ** AxKit.com Ltd ** ** XML Application Serving **
// || ** http://axkit.org ** ** XSLT, XPathScript, XSP **
// \\| // ** Personal Web Site: http://sergeant.org/ **
\\//
//\\
// \\
