Mike wrote: > My concern is that actually connecting to the database is the most > expensive task. > After a connection is established, queries are not that expensive. > > I'm just wondering what is the best thing to do on an application where, > say, 100 users are connected simultaneously and constantly hitting the > database.
100 users hitting the DB "simultaneously" could actually be just 2 concurrent connections. You should be using a connection pool/datasource combination, either based on your J(2)EE container or ASF's Commons DBCP. hth, Manos _______________________________________________ Red5 mailing list Red5@osflash.org http://osflash.org/mailman/listinfo/red5_osflash.org