Re: How many tables per datasource?

2003-06-17 Thread John Paul Ashenfelter
- Original Message - From: "Blood Python" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 8:43 AM Subject: How many tables per datasource? > Hi, how's everyone doing? :) > > I never thought about it until today, when i was asked about it while > explai

Re: How many tables per datasource?

2003-06-17 Thread Jochem van Dieten
Blood Python wrote: > > I never thought about it until today, when i was asked about it while > explaing a bit if mysql for a friend. Is there a rule or best pratice to > know when it's time to create another datasource? Maybe spliting 1 > datasource with many tables on 2 or 3 increases perform

RE: How many tables per datasource?

2003-06-17 Thread Adam Wayne Lehman
Sent: Tuesday, June 17, 2003 8:44 AM To: CF-Talk Subject: RE: How many tables per datasource? there is not real answer to that...as # of tables is really based on your database design..for instance we have a database here which is near 500 tables - what would be the point in creating another datas

RE: How many tables per datasource?

2003-06-17 Thread Robertson-Ravo, Neil (RX)
there is not real answer to that...as # of tables is really based on your database design..for instance we have a database here which is near 500 tables - what would be the point in creating another datasource, imagine all the variables we would have to change! Also, performance is again down to