Subject | Newbie: Query speed and DB size |
---|---|
Author | kogerbnz |
Post date | 2008-03-26T20:37:25Z |
Hello
Just some basic questions to understand performance with FB (and RDBMS
in general).
1) Does the query speed depend on the number of rows in a table?
2) Does the query speed depend on the number of columns in a table,
assuming that I will only query the PK column (select ID from mytable)?
3) OK, I know this is a vague question.
On a "normal" desktop computer say 2MHz and 2GB RAM or something like
it. How many simple queries (like select * from table) can I make in a
second. Is it in the 100's, 1000's etc.?
Thanks :)
Just some basic questions to understand performance with FB (and RDBMS
in general).
1) Does the query speed depend on the number of rows in a table?
2) Does the query speed depend on the number of columns in a table,
assuming that I will only query the PK column (select ID from mytable)?
3) OK, I know this is a vague question.
On a "normal" desktop computer say 2MHz and 2GB RAM or something like
it. How many simple queries (like select * from table) can I make in a
second. Is it in the 100's, 1000's etc.?
Thanks :)