Hi Andre,

> what, in firebird/interbase, is the maximum feasible row width for a

table?

> We have added one field to a specific table which has been denormalized

for

> lookup purposes and now the table performs like a dog (550 ms for a fetch

of

> one field using an indexed field to locate record from table with 4 rows)
> We are using firebird 1.2 sql dialect 1, but our end users could be using
> either firebird or interbase.

There is no Firebird 1.2 :-)

Anyway, what is the current row size?

What is your particular query? Is it a:

select * from lookuptable -> cause that really cannot be slow.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com