Subject Re: [firebird-support] Large record count - will it work?
Author Thomas Steinmaurer
> Aage Johansen wrote:
>> If ECO generates Firebird-unfriendly SQL you may find yourself in a
>> position where you cannot really fine tune the queries. This may be
>> the case for any db system, and I don't know ECO at all. Just a
>> faint recollection of someone having problems with generated SQL
>> which were not optimized well (don't remember which db server).
>
> If that happens I hope the ECO people will try to generate better SQL or
> at least help me inject special SQL where needed.

This is in fact a general problem with OR mappers (although ECO isn't an
OR mapper only) that the generated SQL isn't always optimal. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/