TommyV10
asked on
JSP, is it slow?
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.
Thanks,
Tom
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.
Thanks,
Tom
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>made a couple of test pages to see how it feels.
Please show us one.
Please show us one.
ASKER
Sorry, I forgot about this one.
Thank you jarasa for you tips and comments. I have taken your advice and am now looking at developing under a J2EE environment. It is a big step, but so far you are right, I'm not dissapointed.
Thank you jarasa for you tips and comments. I have taken your advice and am now looking at developing under a J2EE environment. It is a big step, but so far you are right, I'm not dissapointed.
I'm glad to hear that tommy. and thanks for the Points.
:c))
Javier
:c))
Javier
Javier