Subject | Litlle performace hel for FirebirdSQL 2 |
---|---|
Author | Sasa Mihajlovic |
Post date | 2008-01-09T23:22:49Z |
Hi,
I have firebird database around 2GB with some tables over milion
records and my db is very slow, I try with indexing, recomputing
indexes and perfomance are stil slow.
I know that this is a general question without any example but if I try
to export dana on oracle XE on same PC, with same strusture (fields,
indexes, ...) I get 5 time faster response for any query it is
imposibile that oracle is 5 times faster there is some tip that I don't
work and should be???
Thanks in advanced...
I have firebird database around 2GB with some tables over milion
records and my db is very slow, I try with indexing, recomputing
indexes and perfomance are stil slow.
I know that this is a general question without any example but if I try
to export dana on oracle XE on same PC, with same strusture (fields,
indexes, ...) I get 5 time faster response for any query it is
imposibile that oracle is 5 times faster there is some tip that I don't
work and should be???
Thanks in advanced...