On 15 Nov 2002 at 17:12, Bogus aw Brandys wrote:

> Hello,
>
> I have to create database to maintain a couple of document types
> (about 30 in 5 cathegories) about ours customers. I'm newbie and maybe
> this is a silly question ,but what is better to create: one table for
> each cathegory or one simple table with all document types ? I mean
> what is then faster in queries ?

It depends, are there links between different categories, for example if one category
were invoices, and another were payments, then there is a link between them, so
you would want them in different tables. If there is no link, then there is no reason
for having them in separate tables, and you can simplify the program code. As for
queries, a properly designed database, will have high performance, even with
record counts that exceed 500,000 records. The only time I have seen a database
with poor performance, was when the data and the application didn't fit the SQL
model well, and it wasn't possible to change it.