Subject Re: [ib-support] error: key size too big for index
Author Svein Erling Tysvær
I guess (I haven't measured) it could be a bit slower, but if you've ported
it from MS Access the biggest issue will be to start thinking in terms of
sets of data rather than tables. Treating Firebird/Interbase as a desktop
database is possible, but it really is a client/server database and will
perform lousy until you change your way of writing programs and take
advantage of client/server techniques.


> I need quickly find out, if there is record matching all three
>fields. Form performance point of view, are three separate indexes
>slower or is it the same as compound index? (Program is ported from
>MS Access, so rules for using indexes maybe different).
>Thank you for advise.
>Regards Vlada