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

RE: How many tables per datasource?

2003-06-17 Thread Adam Wayne Lehman
: 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 datasource

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

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 explaing a bit if