Performance with large databases

[Dan Barron <db...@mail.acponline.org>]

I'm considering Xindice for a project here. It's so easy to use and does all I need it to do. But my concern is performance. The project I'm thinking of will require a DB with in the neighborhood of 5 million records, each and XML file of 5-15K. I don't know too much about our hardware other than they are Sun and are maintained by our IS department so I'm sure they're up-to-date hardware. Performance is crucial because the database will serve dynamic data live to a website.

I was wondering if anyone with experience could tell me if Xinidice would handle this. Any one out there with large databases?

Any help would be appreciated.

dan


____________________________________________________________________
Daniel W. Barron
Senior Systems Analyst/Application Developer
American College of Physicians-American Society of Internal Medicine
Tel: (215) 351-2617     Tel: (800) 523-1546 x2617
Fax: (215) 351-2644    E-mail: dbarron@mail.acponline.org

Re: Performance with large databases

["Mark J. Stang" <ma...@earthlink.net>]

It should.   Kimbro has done some tests and it looks fast.   How fast do you
need to be?   Is it a multi-user project?

Mark

Dan Barron wrote:

> I'm considering Xindice for a project here. It's so easy to use and does all I need it to do. But my concern is performance. The project I'm thinking of will require a DB with in the neighborhood of 5 million records, each and XML file of 5-15K. I don't know too much about our hardware other than they are Sun and are maintained by our IS department so I'm sure they're up-to-date hardware. Performance is crucial because the database will serve dynamic data live to a website.
>
> I was wondering if anyone with experience could tell me if Xinidice would handle this. Any one out there with large databases?
>
> Any help would be appreciated.
>
> dan
>
> ____________________________________________________________________
> Daniel W. Barron
> Senior Systems Analyst/Application Developer
> American College of Physicians-American Society of Internal Medicine
> Tel: (215) 351-2617     Tel: (800) 523-1546 x2617
> Fax: (215) 351-2644    E-mail: dbarron@mail.acponline.org