Speed to access data using ASP generated by Frontpage

[delorfra]

Is there any known speed problem using ASP generated by Frontpage 2K ?

Intranet Server : NT 4.0 /IIS 4.0

I have used the FP wizard to set up a data connection to an Oracle database, to perform a simple SQL select statement. Over an intranet, I could compare the performance against a CGI program (provided with PC Soft's WEBDEV) accessing Oracle through a native access (so not using ODBC) to fetch exactly the same data. The ASP access was easily 10 times slower.

Any idea ? Is there anything that could have been not so well set up concerning ASP (e.g. IIS 4) or is it the ASP generated by FP 2K?

Thanks

 

[link9]

yea. FP makes some really ugly and inefficient code. Best bet is to hand code all your pages -- **almost** always.

Tough to say exactly what is slowing it down, but an ODBC connection is definitely going to be slower than your native connections -- since you have the extra layer of translation.


Paul Prewett