Your opinion about storing invoice line items as a list rather than records

[Mike Matthews]

Hello Das

Always store each line as separate records in a table.  Not as a List as you suggest.  When you get corruption, you cannot rebuild, and at some time, you will get damage.  The data will be slow to search as well, as no index will exist for any of the data.  If you start to build an index record of the lines, you might as well just make the whole line.

This is good advice, even if you were not using SQLand still using the Omnis datafile.

Mike


Mike Matthews, Managing Director, Lineal Software Solutions Ltd

Apple Reseller, Microsoft Partner, SQLWorks Business Partner
phone: 01271 375999 | web: lineal.co.uk | email: mike.matthews at lineal.co.uk

> On 20 Jan 2018, at 00:58, Das Goravani <das at goravani.com> wrote:
> 
> 
> What’s your opinion about
> 
> Line items of an invoice
> 
> store them as a complete list in the invoice header, store a list with each invoice
> 
> or store them as small records, each line item is a record
> 
> 
> 
> only advantage I can see for line item records is that you can search up what invoices a certain product appeared on real fast, but that’s not that common of a search request
> 
> 
> seems to me you can safely store the invoice line items in one list in the invoice header
> 
> 
> das goravani
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com