Hi!

If there is a slight difference in statistics, Firebird may in some
cases choose a different plan (which may change the performance
dramatically). Or it may be that you have indexes inactive in embedded.
If the PLAN is identical on both Superserver and Embedded, then I'd be
very surprised to see such huge differences. For us to give a better
answer to your question, you have to supply us a lot more details.

HTH,
Set

danyschaer wrote:

> Hi all;
>
> Testing both type of Firebird flavors (Superserver 2.1 VS. Embeded
> 2.1), just one connection in both tests, same database in both tests,
> same machine; I see very different performance resonving complex select
> commands. For a case, exactly same command runs very fast in
> Superserver (2 seconds) and very slow in Embeded (108 seconds).
>
> Is that normal?, or, is it possible to get same performance with
> embeded?.
>
> Thank you.
>
> Dany