Hi,
This is Srini from Casecentral in San francisco.
Does Texis support creating of views? i.e. if I have 2-3 tables, of the same columns etc, can I do union of the 3 tables and define a view?
The SYSTABLES does have a table type as view (V).
You would need to do a little bit of programming to make that work, for example the appliance does it with the "Meta Search". The right way to do it will depend on the requirements of you search, particularly as far as results order go.
As an example newspapers and other archives may frequently partition based on year, as many queries are for recent stories, or date based, so only the appropriate tables need to be accessed.
Hi John,
Thanks.
Can we make Meta Search or <fetch Parallel> work with sql selects? It looks like fetch is only for walking urls.
in short is there any federated query possible on a group of tables?
Yes, each server would have the same script that would return the results in a common format, e.g. CSV or XML, then fetch parallel would fetch the results in parallel.
You could then timport the results and use <sort> to sort. If you are paging over the results it does require extra book-keeping.
