| Subject | Re: [firebird-support] Trouble of making union of many tables to one view |
|---|---|
| Author | Jacek Borowski |
| Post date | 2005-07-26T15:27:58Z |
Hi,
difficult for me to explain why we are using this architecture, but it is
result of our considerations. For some global analysys we need global views
grouped by localisations (shops) , cities, regions, countrys and whole
organization.
Analisys grouped by regions works fine and smooth.
Sometimes we are preparing agregated data in special tables, but in other
cases we need prepare calculations on the fly.
Maybe some other solutions ?
J've made views grouped by regions and then, selectable procedure, which
returns result for country and so on. But this solution is very bad.
Regards,
Jacek Borowski
>> How You can make one view from 100 vievs from 100 tables each?The central database, working as mirror for every localization. It is
>It is 10000 streams. Afaik Firebird's limit is 128.
>> I have about 100 tables with same structure.
>Then why not just use single table ?
difficult for me to explain why we are using this architecture, but it is
result of our considerations. For some global analysys we need global views
grouped by localisations (shops) , cities, regions, countrys and whole
organization.
Analisys grouped by regions works fine and smooth.
Sometimes we are preparing agregated data in special tables, but in other
cases we need prepare calculations on the fly.
Maybe some other solutions ?
J've made views grouped by regions and then, selectable procedure, which
returns result for country and so on. But this solution is very bad.
Regards,
Jacek Borowski