We are implementing our Spirare software with both DBISAM and Elevate DB
that we have bought. I have some technical question that your answer will be
very important for us.

Which of these database is good for using with:

Approximately 500 to 5000 simultaneously users?
A database with 30 tables?
Empty database size 2 MB?
Big database size 5 GB?
Which is faster?


Best regards
Hamid

HRB


I'm currently using ElevateDB but used to use DBISAM

>Which of these database is good for using with:
>
>Approximately 500 to 5000 simultaneously users?

Much as I love Tim's products with that many simultaneous ACTIVE users I'm betting you'll need some sort of load balancing middleware.

>A database with 30 tables?

Either. My main app has more than twice that number and I've seen bigger

>Empty database size 2 MB?

Why should that matter

>Big database size 5 GB?

Either. The biggest database I have under DBISAM the biggest table is just over 4GB. With ElevateDB my biggest is only about 1.5GB so far but growing.

>Which is faster?

Bad question to ask. Its to general. You need to specify the operation, and if its SELECT then the query as well. Ideally you need to test it yourself under something like real world conditions.


Roy Lambert [Team Elevate]

"Roy Lambert" <roy@lybster.me.uk> ha scritto nel messaggio
news:1E1744A6-3272-4073-B44B-34EE3D4B55C9@news.elevatesoft.com...
> HRB
>
< cut  >

>>Which is faster?
>
> Bad question to ask. Its to general. You need to specify the operation,
> and if its SELECT then the query as well. Ideally you need to test it
> yourself under something like real world conditions.
>


Why bad question ?
Same table, same query but different DB.
Surely two different response....!! or not ?

C.

camperos

>Why bad question ?

As I said before its to general. If I asked which is faster - an aeroplane or a car and forgot to mention the trip is only 5 miles you'd probably give the wrong answer.

>Same table, same query but different DB.
>Surely two different response....!! or not ?

Who knows. It depends on the number of records, the nature of the process (eg SQL vs navigational), how complex it is, what indices are in place, wether its exclusive or not, how well Windows is caching the data and a slew of other things.

You posted that you're going to be implementing your software with both DBISAM and ElevateDB so why will an answer to this question be important?

Roy Lambert [Team Elevate]

Hamid,

Answered via email:

<< Approximately 500 to 5000 simultaneously users?

A database with 30 tables?

Empty database size 2 MB?

Big database size 5 GB?

Which one is faster? >>

If your primary concern is performance, especially with larger amounts of
data, then ElevateDB is the better choice.  However, you're going to have
issue putting 500-5000 *concurrent* users on any ElevateDB database with
some load-balancing, such as using multiple servers with replication and
other techniques.

--
Tim Young
Elevate Software
www.elevatesoft.com