Subject Re: [firebird-support] singleton table with many fields
Author Alexandre Benson Smith
Em 16/7/2013 00:03, thp_pkmi escreveu:
> Hi all,
> I have a table that always contains 1 record and have about 50 fields with various type. It's function is to store system parameters and is accessed very frequent from application and also from database triggers and stored procedures. Is it wise to utilize a singleton table like this, or is it better to implement a table with many records storing parameter name, type, and values ?
> Thank you very much.
> Regards,
> Tjioe

I doubt it will make any diference...

I think you will have a dozen or so records.. that will fit in a single

Since every operation will read/write a page...

see you !