Hello All,

I have a design decision to make w.r.to usage with
Hibernate, kindly advice:

(I use MySql-5 with Hibernate-3)

For ex:
I have several Schools with several student record
tables (1095 tables) in it. As the data increase in tables,
it increases the search time, for which i thought i shall use
different database in MySql for each School (which have
the same table structure).

In hibernate getting handle to a session factory is taking
lot of time (35sec per session factory, as i have lots of
resource mapping files). If i use several databases, i need
to have session factory per database and this increases the
startup time.

Kindly advice me if the following is advisable:
1) Going for different databases instead of using one
database. (will it effect in any way if later i change
from MySQL to Oracle etc)

2) Is there any better way to minimize the session startup
time? With several databases, there will be several session
factories and is it good to have them in such way?

I was thinking to make the session factories as variables in
application context in app server. Will that help!?


Thanks in advance,
Regards,
Sanjeev