We've had to limit the number of results returned in WebPublisher (& now Pro), to 500, since even that can take 20 seconds to return (on a DB of 1100 records).

And this is on a fast box (Win2k3, Dual P4 XEON 2.2GHz, 2 Gig RAM, SCSI disk, etc).

We have some DBs that have 60,000+ records, you can forget doing large queries against these.

DB/TextWorks seems to suffer in the same way.

Specific searches seem to perform fine, suggesting the indexing is working well, however, record retreival seems to be quite slow.

Any suggestions for speed increases?

Later'ish
Craig

Are you sorting? What version of WebPublisher PRO are you using? Does your textbase have a default sort specified?

Hi Lisa,

we're just doing XML output so (I think) that relies on the default sort order.

Though we did have this issue before we moved to XML based output. I had hoped that one of the following would help:
HTML output to XML output.
WP6.1 to WPPro7.01.
CGI to ISAPI DLL.

But none of these seem to have made much difference. Even the faster development box still takes a similar time to retrieve records.

Most are sorted by a Date field, while the biggers ones are by Created_Ordered | Title.

Where Date and Created_Ordered are both date type fields.

Our production system is still running WebPublisher v6.1, and that's where we first had speed issues (three processor P3-500, 2 gig ram, scsi disk). The dev box that I'm using to migrate our sits/DBs from WP6.1 to WPPro7.01, is running WebPublisher Pro 7.01.

Hope that gives you more of a lead.

I might try rebuilding the sort index and see if that helps.

THanks
Craig

Sorting doesn't rely on the index. It happens dynamically before the report is displayed.

You might want to try removing your textbase default sort, just temporarily, to see if you get a radical performance improvement.

Just removed the default sort.
No difference in performance.

Does InMagic have any performance benchmarks that I can compare against?

Any suggestions on increasing retrieval speed. I have a canned query in CS Webpublisher that retreives just over 1600 records and sorts them into a simple subject list with record totals. The list generated is not very long in terms of the html page that is generated but it takes up to 10 seconds to display. And I noticed that if I run the same query with only a couple hundred records that it displays almost immediately.

Is it the sort that takes the time to display? I do not see the same lag in the desktop version. Though it definitely is dependent on the number of records being sorted.