Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Scalable site

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While creating a large site with 10000 database connections at a time, what has to take in to account in the servlet code and where to write the JDBC connection ?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
10000 database connections at one time. That is not just large, that's huge. Do you really need that? Do you actually have 10000 pages in the process of being rendered all at once? Wow. If it's not a secret, what hardware and software architecture have you gone for for a site this busy, and what market generates that much traffic?
Anyway. If you don't already have it, you realy need high-performance connection pooling. Opening and closing that many connections would kill the system without ever getting any useful output. You probably want to consider data cacheing too. If a large proportion of the requests are for the same data from the database you might consider a separate thread which updates a "static" copy of the data for the servlet container(s) to return from rather than tying up the database all the time.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic