We are into the maintenance of web application. It is an intranet applciation. The details are as follows
Backend : SQL server 2000
Front end : ASP/ XML/ XSL
ASP pages initiates the execution of the SPs to get the data into a recordset. Then by running a 'While' loop, an XML file is created for that data from the recordset. The XML file is then presented using an XSL file. XML file contains tags for different properties of each component like 'on click even' , 'on mouse over', 'text' , visibility' , type of the compoentn - whether it is a text box/ button etc
The screeens are extremely slow. The databse is quite big and growing fast. But the indexes are properly defined, so I dont think the data retreival is taking much time. I tried to execute the SPs independantly and it is fast.
The screens are very heavy with a lot of controls - which includes lists, data entry compoennts, radio buttons, buttons etc. The server is in the local network.
Does any one know whether the XML creation and presentation using XSL is a time consuming process or not.
What is the best way of creating dynamic pages in asp?
Does the methodology of using the XML/XSL is of any benefit?