FP2003 slow with large dataset

  • Thread starter Thread starter Graham Stevenson
  • Start date Start date
G

Graham Stevenson

Hi,

I'm using FP2003 to create a WSS-based site. When I connect to a web service
which returns lots of data (some 4000+ rows in a dataset), FP2003 grinds
almost to a halt.For example in split view mode, click in the dataview grid
and it goes into 17/18 seconds of 100% cpu activity. Click on a line of code
and it does the same. Makes using it almost impossible.

Running on a 1G PIII with 512M RAM and XP Pro. Server running WSS is
completely separate box over a 100MHz LAN. NB No network activity when FP
slows down.

Other pages are fine - even if this slow page is open (but not active). Its
got to be down to FP caching this data in the page !!!.

FP currently claims to be using 173 MBytes, but the whole system is at
549M - I suspect FP is NOT telling the truth, as it has claimed 240M+
earlier and the overall usage has NOT come down again.

Every click on FP takes 15+secs of 100%cpu time, even the close button. When
it eventually closed (from above) it returned me to 269M used (ie returning
some 280 M !!!!).

Hope someone can help me here as this is making the otherwise excellent
product unusable.

Thanks

Graham
 
Hi Graham,

The performance issue you describe is a known issue, and is a result of
several different factors.

Personally, I think the most effective way to combat this perf issue is the
use the Data..Style menu to reduce your view to showing only a couple of
items from your Data Source. Then do the edits necessary and
layout/formatting you want to do, save the page, then change the style back
to showing all items and save the page again.

While this is far from ideal, I think you will find the performance improves
well enough for you to get your work done.

By the way, is this a public Web Service? I'd like to take a look at
mapping performance times against it if it is.
 
John,

Thanks for getting back (and so quickly !!).

Sorry for my delay but (see my other post) my post was deleted - so I
couldn't see the reply.

Don't use news a whole lot and had to get a new reader etc......as
advised by Mike in his response.

I'll certainly try your suggestion as it may make it usable.

As to the 'public' service, sorry its not, as it contains private
client data, however I could make this available to MS for a dedicated
support issue, say for a short time.

If you want to do this - please respond off-newsgroup using my email
address (minus the ns on nsoxns.com !!). I could then open up my
system here and give you an IP address.

I would need you to agree to keep the data confidential however :-)) -
not that it will be a lot of use to you !!.

Thanks

Graham
 
John,

There is another possible side-effect of this performance issue, and
thats on the live page (ie no FP).

The WebPart times out if I enable Filter at runtime and then try to
filter the dataset.

Tried extending the default WSS 7000 mS to 20000 mS - and it still
just times out.

Thanks

Graham
 
Hi Graham,

Yeah, this is a known limitation unfortunately. When you enable the ad-hoc
filtering, all of the filterable data gets rendered into the filter
drop-downs, which can take a really long time and cause it to time-out.

I would recommend not allowing filtering in IE, but rather create a few
filtered views that people can choose between from a hyperlink, if that
makes sense.
 
Back
Top