Hi there,
I've created my second test, mentioned below. I now have 150 projects,
with a total of 100,000 records. This equates down to about 760 tables at
the same time. PostgreSQL handles this quantity of tables just fine. My
searches in a particular project are fast, and response is fantastic. So,
my conclusion....
A high number of tables in PostgreSQL does not slow down access, when you
limit your queries to a small subset of those tables.
Gerald
On 31-Jul-98 Gerald Brandt wrote:
> Hi there,
>
> Okay, I've created a test. The test has 100 projects, and each project
> has 500 entries. So basically it created 500 new tables, and 50000
> records. Speed difference is negligible. I do not notice a slowdown,
> although I have not done actual timing tests.
>
> Today, I will add 50 more projects with 1000 entries each (again 50000
> records), and essentialy double the size of the database, but not
> drastically increase the number of tables.
>
> 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@hvdc.ca
> Manitoba HVDC Research Centre http://www.hvdc.ca
>
---
#include <std_disclaimer>
Gerald Brandt gbr@hvdc.ca
Manitoba HVDC Research Centre http://www.hvdc.ca