Re: database performance questions

>The properties may be numeric, strings or date-time values, so I currently
>decided to build several tables: one for holding base information about the
>document ( author, createtime , ...) , one table for numeric fields, another
>for their contents, one for string-content and so on. This ends up in loads
>of related tables and I' worried about performance problems running queries
>on this structure. ( concerning an amount of estimated 100000 up to 200000
>documents. )

i think i know this scenario pretty well as we have developped a similar solution (have a look at http://www.rsp.de/ :-) )

anyway, of course the performance of such a crosstab-design is not as fast as native, rowwise storage. ...depends on your demands - what do you want to do?

ciao, jan

http://www.rsp.de - Software zur effizienten Erstellung und Verwaltung von Gutachten, Analysen, Pruefprotokollen etc. Received on Fri Feb 04 2000 - 00:00:00 CET