Which Is better : Multi databases or single database [closed]

Question

I have about 1.63 GB text information in 11 databases.

these databases information is not realated to each other. my application run from DVD i have some problem for first connection to each database its take some moment to open connection to each database. I have a question: which is better? 1-collect all tables in a single database increase my application speed? I created my databases with SQLCE 3.5 and i'm using entity framework.

Answer 1

Your question really doesn't provide enough good context to answer properly, but if the initial connection latency is the problem then naturally reducing the number of outbound connections will improve performance. How a single database affects performance and scalability is impossible to know given the lack of context.

Answer 2

Regardless of the number of databases, generally you should be pooling connections...

Pooling leaves a set of connections already established and ready to use with no overhead