I have an application that is currently developed as an MS Access project connected to an MS SQL Server. My intention is to redevlop this as a web based application and I thought I'd give JSP a go. I've set up a Tomcat 5.0 development server and made a couple of test pages to see how it feels. I'm using the Microsoft SQL server driver for JDBC to connect to my database to run a couple of simple to queries and iterate through a recordset to display the results. I like to use stored procedures rather than sending SQL strings to the server so I'm using a CallableStatement and defining the parameters for it.
The problem is it seems to be running very slowly, regardless of the complexity of the query or the size of the returned recordset. Is this a general problem with JSP? Would it be faster if I ran the code in a servlet rather than in the .jsp page?
My application currently makes lots of calls to the SQL server for things like drop boxes, list boxes and so I'm a little ancious about this apparent lack of speed. Would you recomend I stick to JSP or would PHP or ASP be a better option.
Any tips on the performance of jsp with SQL server(or even other DBMSs) and recomendations on other platforms would be much appreciated.