|Subject:||Need Advice on Secondary Indices
|Date:||Wed, 18 Apr 2018 13:07:16 -0700
I am making a kind of ticketing system. It will require several views
(setranges) such as viewing tickets assigned to certain individuals or
everybody, open/close tickets, by due date or priority and many more.
The easiest thing is to just define all the secondary indices that are
required. The problem is that I worry about corruption.
As an alternative I was thinking of having multiple tables with a few SI
each and keep them in sync. On the form the user would click the view
they want and the fields would be redefined to reflect the table with
the required SI. That sounds like a headache.
I am interested in hearing about other possibilities. Thanks.