PDA

View Full Version : jsp/servlets & large mysql database



pdanese
10-23-2004, 08:14 PM
Hi,

I'm currently running a web-site that gets ~ 10-15K hits / month (don't know if this is relevant).

The site is essentially a search engine. Each search engine query uses Jsp/servlet technology to interrogate a MySQL database table that contains > 4 million records and return a user-specific result.

My current web-hosting agent disabled my jsp abilities recently b/c the system was consuming too much of the common server computing resources.

I'm thinking about trying a VPS (westhost's ultimate version). I'm just wondering if anyone has a sense of whether this plan will support a relatively fast response time for a jsp/servlet-mediated query of a large MySQL database table.

Thanks for any info.

pdanese

-go sox