--- In firebird-support@yahoogroups.com, "Sasa Mihajlovic"
<majstoru@...> wrote:

>
> 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???
>

Your question is quite vague and has little chance at getting a
sensible answer. Review the following document and then re-phrase your
question.

http://www.catb.org/~esr/faqs/smart-questions.html

Clearly you have a database structure with tables with estimated
record counts and indices, and clearly you know the query you are
running on both Oracle and FB.

You need to provide.

Relevant table structures, including any available indices and the
estimated record counts. Also note any distribution peculiarities (eg.
99.99% of records have the same value in this field).

The query you plan on running

The PLAN that the Firebird optimiser generated when looking at your
query. (most tools will tell you this). If you understand what the
PLAN means, suggest an alternative PLAN you feel Firebird should have
selected.

You also need to tell us what you mean by slow. Are you measuring CPU
load, Disk load, concurrency?

The only generic 'trick' I can offer is to remind you that Firebird
handles garbage collection, so if your database is messy, performance
will be impacted. Backing up the database using gbak and -g flag, then
restoring that backup file will give you a nice clean database to
compare apples and apples.

Adam