From: | Gerald Brandt <gbr(at)hvdc(dot)ca> |
---|---|
To: | James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us> |
Cc: | pgsql-admin(at)postgreSQL(dot)org |
Subject: | Re: [ADMIN] Limits on Tables? |
Date: | 1998-07-28 16:25:36 |
Message-ID: | XFMail.980728112536.gbr@hvdc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi James,
Actually, it all COULD be placed into the base tables, and in fact it was
before I separated them. I just thought that I would get a speed increase
by more cleanly separating the data. Then I sat down and thought about it
some more, and now I'm not sure. Hence the question...
Gerald
On 28-Jul-98 James Olin Oden wrote:
>
>> Hi there,
>>
>> I have an app that has some basic tables. When a new project is
>> created
>> in the app, it creates 5 new tables (inherited from some base ones). A
>> single project will never go outside of its tables.
>>
>> What kind of speed problems will I be seeing when there are a lot of
>> projects? Say I have 100 projects, that would be 500 tables, plus a
>> couple of base tables, say 510 tables.
>>
>> Am I going to start seeing major problems?
>>
>
> Could share with us the tables you are using as base tables? I suspect
> that
> you may not need to do this scheme of duplicating tables, but could
> rather
> have a table that has a project ID, that you use to segregate your
> project
> data amongst these tables. At anyrate I would love to see the tables
> you
> have, and then I would know if how best to help....james
>
>
---
#include <std_disclaimer>
Gerald Brandt gbr(at)hvdc(dot)ca
Manitoba HVDC Research Centre http://www.hvdc.ca
From | Date | Subject | |
---|---|---|---|
Next Message | Shawn T. Walker | 1998-07-28 22:11:28 | Creating Groups |
Previous Message | James Olin Oden | 1998-07-28 16:13:48 | Re: [ADMIN] Limits on Tables? |