Be aware of one thing: having a seperate table for each product type makes
it extremely difficult to scale your application. In your plan, everytime
you add a new product type you have to create a new table. Which means if
you have any sort of general "search all product types for this
attribute"
Marcin ..
Marcin Inkielman wrote:
> On Sun, 27 Aug 2000, Miles Thompson wrote:
> >
> > Each table you would create for a different type of product can be replaced
> > with a single column, say "product_type", which you could use to broadly
> > classify your items: cars, boats, computers, applian
Andrew,
As I was reading Marcin's reply to my message of earlier today I began to think of
how PGSQL has been extended. My thinking was purely relational, an "objectified"
approach would probably be worth considering.
[EMAIL PROTECTED] wrote:
> On Sun, 27 Aug 2000, Miles Thompson wrote:
>
> > O
On Sun, 27 Aug 2000, Miles Thompson wrote:
> Other columns could simply be labelled "descrip1", "descrip2", "descrip3", as
> many as you need, for the different attributes of each item. So "descrip1" may
Now someone once said to me "If you find your labeling your fields x1, x2,
x3... then your
On Sun, 27 Aug 2000, Miles Thompson wrote:
>
> Each table you would create for a different type of product can be replaced
> with a single column, say "product_type", which you could use to broadly
> classify your items: cars, boats, computers, appliances, etc.
don't you think that this is exect
Marcin ... comments below
Marcin Inkielman wrote:
> On Sun, 27 Aug 2000, Jurgen Defurne wrote:
>
> > Any time your design is heading in this direction, take a good hard look
> at
> > it. Proper organization with the appropriate indexes is the way to go.
> >
> > With tens of hundreds of tables,
On Sun, 27 Aug 2000, Jurgen Defurne wrote:
> Any time your design is heading in this direction, take a good hard look
> at
> it. Proper organization with the appropriate indexes is the way to go.
>
> With tens of hundreds of tables, how will you decide which to use?
> How will you write your que
Marcin Inkielman wrote:
> On Sat, 26 Aug 2000, Jurgen Defurne wrote:
>
> > Date: Sat, 26 Aug 2000 07:36:25 +0200
> > From: Jurgen Defurne <[EMAIL PROTECTED]>
> > To: Marcin Inkielman <[EMAIL PROTECTED]>
> > Cc: postgreSQL general mailing list <[EMAIL
Marcin Inkielman wrote:
> HI!
>
> I have such problem:
> Is the amount of tables limited in Postgresql7.0?
> Has anybody tried to use EFFECTIVELY a database
> with 1 tables at all?
>
> Thx for help.
Are you really sure you NEED a database with 1 tables ?
Jurgen
