Re: [PERFORM] Performance vs Schemas

2004-10-19 Thread Aaron Werman
- Original Message - From: "Gregory S. Williamson" <[EMAIL PROTECTED]> To: "Igor Maciel Macaubas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 14, 2004 2:45 PM Subject: Re: [PERFORM] Performance vs Schemas Igor, I'm not sure if it is

Re: [PERFORM] Performance vs Schemas

2004-10-14 Thread Iain
have experienced the same speedup as the data tables would be more compact.   regards Iain - Original Message - From: Igor Maciel Macaubas To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 3:38 AM Subject: [PERFORM] Performance vs Schemas Hi all,   I rec

Re: [PERFORM] Performance vs Schemas

2004-10-14 Thread Neil Conway
On Fri, 2004-10-15 at 04:38, Igor Maciel Macaubas wrote: > I have around 100 tables, and divided them in 14 different schemas, > and then adapted my application to use schemas as well. > I could percept that the query / insert / update times get pretty much > faster then when I was using the old un

Re: [PERFORM] Performance vs Schemas

2004-10-14 Thread Gregory S. Williamson
especially under the performance tips section. HTH, Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Igor Maciel Macaubas [mailto:[EMAIL PROTECTED] Sent: Thu 10/14/2004 11:38 AM To: [EMAIL PROTECTED] Cc: Subject:[PERFORM] Performance vs Schemas Hi all, I

[PERFORM] Performance vs Schemas

2004-10-14 Thread Igor Maciel Macaubas
Hi all,   I recently migrated my database from schema 'public' to multiple schema. I have around 100 tables, and divided them in 14 different schemas, and then adapted my application to use schemas as well. I could percept that the query / insert / update times get pretty much faster then wh