More "newbie" questions.

Suppose I have three book databases that I want to keep separate as
far as searching is concerned. Am I right in thinking that I could
have eg. one database with three different tables or three databases
with one table each ?

If so then what are the reasons why one would choose one ahead of the
other ?=20

Can one have concurrent connections to multiple tables in one database
on a MySQL server ? Concurrent connections to multiple tables in
multiple databases on a MySQL server ?=20

Any input appreciated.

Regards, John.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: More "newbie" questions.

Hello John,

Yes you can have it both way.

However, for the sake of simplicity I personally will go with one database and
3 tables.

Also, if the 3 tables share the same structure, I will go with only one table.

That means with a single connection you are able to search the information.

This scheme also simplifies your insert/update/delete since you always work
with only one database and probably one table.

Finally, for sure you can have concurrent connections to multiple tables in
one database as well as concurrent connections to multiple tables in
multiples databases. As an example some Internet Service Provider (ISP)
provides MySQL as a service to some of their customers and each of these
customers have their own database that contains their own tables.

Hum! another reason to use only one database in your case!

Regards,

Bernard

On Saturday 04 December 2004 18:55, John Fitzsimons wrote:
> Suppose I have three book databases that I want to keep separate as
> far as searching is concerned. Am I right in thinking that I could
> have eg. one database with three different tables or three databases
> with one table each ?
>
> If so then what are the reasons why one would choose one ahead of the
> other ?
>
> Can one have concurrent connections to multiple tables in one database
> on a MySQL server ? Concurrent connections to multiple tables in
> multiple databases on a MySQL server ?
>
> Any input appreciated.
>
> Regards, John.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: More "newbie" questions.

On Sat, 4 Dec 2004 20:02:20 -0500, Bernard Clement wrote:
=20
Hello Bernard,

>Yes you can have it both way. =20

Good ! I was hoping someone would say that. :-)

>However, for the sake of simplicity I personally will go with one =
database and=20
>3 tables.

Okay, that has some advantages as the search page will be pretty much
identical for accessing each table. I might even be able to work out
how to search three different tables from the one search page.

>Also, if the 3 tables share the same structure, I will go with only one =
table.

Well, I WOULD go for that BUT my "key" column is the ISBN of a=20
books database and two tables may have the same ISBN but different
prices. :-(

>That means with a single connection you are able to search the =
information.

>This scheme also simplifies your insert/update/delete since you always =
work=20
>with only one database and probably one table.

Yes, that is certainly appealing.

>Finally, for sure you can have concurrent connections to multiple tables=
in=20
>one database as well as concurrent connections to multiple tables in=20
>multiples databases. As an example some Internet Service Provider (ISP)=
=20
>provides MySQL as a service to some of their customers and each of these=
=20
>customers have their own database that contains their own tables.

>Hum! another reason to use only one database in your case!

Well, my hosting company allows three MySQL databases. I don't think
they mention tables so perhaps that is an unlimited number ? :-)

Thank you for your comments Bernard.

Regards, John.


--=20
****************************************************
,-._|\ (A.C.F FAQ) http://clients.net2000.com.au/~johnf/faq.html
/ Oz \ John Fitzsimons - Melbourne, Australia.
\_,--.x/ http://www.vicnet.net.au/~johnf/welcome.htm
v http://clients.net2000.com.au/~johnf/ =20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re[2]: More "newbie" questions.

Your key could be the combination of the columns of ISBN + BOOKSTORE. This=
would be expandable for a fourth store, etc. Keeping it simple usually=
means a solution that is easier to maintain.

Marcel

*********** REPLY SEPARATOR ***********

On 05/12/2004 at 18:11 John Fitzsimons wrote:

>On Sat, 4 Dec 2004 20:02:20 -0500, Bernard Clement wrote:
>
>Hello Bernard,
>
>>Yes you can have it both way.
>
>Good ! I was hoping someone would say that. :-)
>
>>However, for the sake of simplicity I personally will go with one
>database and
>>3 tables.
>
>Okay, that has some advantages as the search page will be pretty much
>identical for accessing each table. I might even be able to work out
>how to search three different tables from the one search page.
>
>>Also, if the 3 tables share the same structure, I will go with only one
>table.
>
>Well, I WOULD go for that BUT my "key" column is the ISBN of a
>books database and two tables may have the same ISBN but different
>prices. :-(
>
>>That means with a single connection you are able to search the
>information.
>
>>This scheme also simplifies your insert/update/delete since you always
>work
>>with only one database and probably one table.
>
>Yes, that is certainly appealing.
>
>>Finally, for sure you can have concurrent connections to multiple tables
>in
>>one database as well as concurrent connections to multiple tables in
>>multiples databases. As an example some Internet Service Provider (ISP)
>>provides MySQL as a service to some of their customers and each of these
>>customers have their own database that contains their own tables.
>
>>Hum! another reason to use only one database in your case!
>
>Well, my hosting company allows three MySQL databases. I don't think
>they mention tables so perhaps that is an unlimited number ? :-)
>
>Thank you for your comments Bernard.
>
>Regards, John.
>
>
>--
> ****************************************************
> ,-._|\ (A.C.F FAQ) http://clients.net2000.com.au/~johnf/faq.html
> / Oz \ John Fitzsimons - Melbourne, Australia.
> \_,--.x/ http://www.vicnet.net.au/~johnf/welcome.htm
> v http://clients.net2000.com.au/~johnf/
>
>--
>MySQL Windows Mailing List
>For list archives: http://lists.mysql.com/win32
>To unsubscribe:=
http://lists.mysql.com/win32?unsub=3Dlmforget2@rogers.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org