AspWebSolution Forums » Products » ASP Report Wizard v2 » Performance with serial reads of datasets

index | search | no replies | posting guidelines | help

login | register

» »

:: Performance with serial reads of datasets :: (7)

Post a New Message | Post a Reply

Oct 7 2004, 5:43 AM

Performance with serial reads of datasets

Ed Dwyer

from: MIdlands. UK Hi,

I am just wetting my feet with ASP Report Wizard V2 and it is a really nice product. I am running the product on our Intranet Server (W2000 Server) and connecting through to a MS SQL Server Database (W2000 Server & SQL2000). One of the datasets I am connecting to contains 48000 records and I am attempting to pull back all the data without a selection. The performance is really slow and I get a time-out message. Yet the SQL Query on the database server completes within a couple of seconds. I have seen another posting on performance and tried the line objWiz.MaxRecords = 50000 but still no luck. Am I missing something obvious or does the product not like doing medium to large serial reads? Any assistance or pointers will be greatly appreciated.

Regards

Edd

Oct 7 2004, 9:35 AM

Re: Performance with serial reads of datasets

whichman

from: Laurel, MD We have tested the ASP Report Wizard with databases up to 200,000 records.

When a database web application is running too slow it could be because of many reasons one of the most common is because of too many security checks by IIS between the web application and the web server, the network access privileges etc.

If your database is on a different server from the web server, try running the report wizard locally just to make sure that it is not a network problem.

Also, check out this utility (free) IIS State to diagnose what your web server is doing.
http://www.iis-resources.com/modules/mydownloads/singlefile.php?cid=15&lid=262

Aslo check this post: http://www.aspwebsolution.com/forums/?tid=325&mid=327

-------------------------
Master of the Game

Oct 13 2004, 10:39 AM

Re: Performance with serial reads of datasets

MannyTC

from: Phoenix, AZ I have been running some tests on a small database. The table I am running the tests with has about 1500 records in it on an MS SQL Server which is on the same local machine as IIS and ASP report Wizard. Normally with the criteria that I will be using in the daily reports the number of records returned will be between 50-100 records. Test runs for this daily type report display on the screen in about 1-2 seconds. If I change the criteria to return all 1500 records the report seems to hang and my CPU on the server goes to 100% with the process DLLHOST.EXE taking up the bulk of that. I have waited up to 5 mins with no report displayed and I end up restarting the IIS services to get the webserver going again. I can't imagine that this performance is normal since this is such a small test database. The tests were also run locally on the IIS server through IE with the same exact results. Can you please offer some assistance?

Oct 13 2004, 12:18 PM

Re: Performance with serial reads of datasets

ghost

from: Washington, DC Are you setting your object to nothing after displaying your reports?
i.e.
objWiz.DisplayReports Set ObjWiz = Nothing

-------------------------
Ghost

Oct 13 2004, 2:43 PM

Re: Performance with serial reads of datasets

MannyTC

from: Phoenix, AZ Yes I am. Here is a copy of the reports.asp file.

<%

If Session("UserName")="" Then
Response.Redirect "login.asp"
End If

Dim objWiz

Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

With objWiz
If CBool(Session("IsAdmin")) Then
.IsAdmin = True
.CanAdd = True
Else
.CanAdd = CBool(Session("CanAdd"))
.CanEdit = CBool(Session("CanEdit"))
.CanDelete = CBool(Session("CanDelete"))
End If

If Session("Departments")<>"" Then
.UseReports = Session("Departments")
End If

If CBool(Session("UseImages")) Then
.LocaleFile = "locale/locale_img.xml"
'.LocaleFile = "locale/locale_en.xml"
Else
.LocaleFolder = "locale"
'.AutoDetectLocale = True
End If

.ImagesUrl = "images"
.Title = "Reports"
.HideProcedures = True
.ReportsFile = Server.MapPath("data/remplusreports.xml")
'.Width = "90%"
End With

'Make sure you initialize before adding any HTML text
'objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("data/sample.mdb") & ";")
objWiz.UsePopupFilters = True
objWiz.Init("Provider=SQLOLEDB;Data Source=HERCULES;Initial Catalog=ReportsTestData;User ID=sa;PassWord=xxxxxxxxx;")

%>

<html>
<head>
<title>Reports Test</title>
</head>
<body scroll="auto">
<div align=right style="font-size:10pt;">
<a href="default.asp"><font color=black face=tahoma>Logout (<%=Session("UserName")%>)</font></a>
</div>
<%
'put this where you want your reports
objWiz.DisplayReports
%>
</body>
</html>

<%
Set objWiz = Nothing
%>

Oct 14 2004, 5:10 PM

Re: Performance with serial reads of datasets

MannyTC

from: Phoenix, AZ Any word on this?

Oct 15 2004, 5:52 AM

Re: Performance with serial reads of datasets

ghost

from: Washington, DC Still can't find anything. Try to scan your PC for a possible hijack

-------------------------
Ghost

Pages: (1) [1]