Monday, 25 July 2016

Re: [firebird-support] Database design. Simple question!

 

My advice is to create that field in the invoices table.

You will always have this field at hand without resorting to an outer join with another table that only has two fields ( the invoice ID and this field ) each time you need to inspect it.

Aldo

El 25/07/16 a las 18:51, shg_sistemas@yahoo.com.ar [firebird-support] escribió:
 

Hello! I  have a FB 2.5 database with a tabla "invoices". I need to add a field in that table which will be null most of the times. Lefts say, that 90% of the records will have this new field in null. 


What is your advice? To create a new table with a FK to "invoices" and save the needed field in a separate table (only when the value is not null of course) of just create the new field in the main "invoices" table?


I think I read somewhere that null fields use very little space in the database. Is that true?


Thanks for any input!!!


Sergio

__._,_.___
Posted by: Aldo Caruso <aldo.caruso@argencasas.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)