Slow WebCompanion 4.0v2 ?

[ulit]

Hi all!

Ok, it's a bit an old WebCompanion but we are still using it because of the unlimited numbers of connections.

I've converted our databases back from Version 5.5 to Version 4 (not only because of the restriction but also because of stability issues). Now I found, that searches with a hit number more than 50 get really slow; if you get 250 hits you have to wait for over two minutes! In contrast, if you do the same search directly at the application, it is always very fast.

Is this a known issue of these older WebCompanion/FMPro Versions?

Thanks!

Uli

[Steven H. Blackwell]

I hope you mean that you "reprogrammed" these databases back to FMP4, and that you did nopt use that so-called "converter" utility. Check to be sure that the copy of FIleMAker Pro is the active application. Also download the latest updater for the 4.0/4.1 series Web Companion and see if that helps your situation.

HTH

Old Advance Man

[Anatoli]

I was running FM4 with WC.

After long and thorough tests I come to conclusion, that FM5 with WC is 2-7 times faster, than v. 4 on NT4 sp6.

[ulit]

Some more info:

I just installed the newest WebCompanion 4.0v3; there is still the long processing time. Also I noticed that after a fresh restart, the speed of a search is normal (less than two seconds waiting time, 260 hits, all are displayed). Any further search takes awfully long (more than two minutes).

Another database which is also opened, doesn't show this effect. It is not using relations while the first one has two relations. Maybe the problem is somewhere there.

Uli

[ulit]

I found the solution!!! HEUREKA!!!

I was using only one Layout in the database, which was containing all fields (around 110). For these special searches with the many hits, only six fields are used for displaying the data. I created a special layout for these replies and , voila, it is quick as in FMP 5 or 5.5

Funny, the newer FileMaker apperantly doesn't bother about the used Layout.

Uli

[Anatoli]

My test shows the same processing time on web in FM5 database with layout with 1000 fields or just 5 fields. Version 5.

[ January 08, 2002: Message edited by: Anatoli ]