Key word to speed up

[timolous]

Hello!

What is the key word to speed up filemaker on web? Is it speed on web connector machine or is it speed on filemaker unlimited machine or is it speed on filemaker server? (we are using web connectorIIS5.0, 2-unlimited, 1-server)

Problems with one over 30 000 record database... (too many thing to do too litle time )

So, how to speed up it?

Timo

[John May - Point In Space]

Do you use a separate LAN between your FM Server and Unlimited machines? Is it at least 100Base-T?

- John

[Anatoli]

What are the machines?

And the connection speeds, please as John asked?

Are you sure, the machines are properly configured?

What is slow?

Is the field, which is slow, indexed?

There is at last 1000 variables in play.

[timolous]

Hello again!

We have 100Base Network. FMserver is behind Firewall. Our Unlimited machines are too behind Firewall, but on different network.

We have 3-Nic:s Firewall. One Nic is connected to outher world and one is connected to allkind off Internet servers and last one is connected to our office network.

So FMserver stands on office network(10.10.0.0) and Unlimited and webconnectors stans at Internet network (10.20.0.0) Everyting is coonected at 100mbit network vie switshes (at full dublex (200mbit)) And everyting works fine. (firewall is configured to allow trafic between 10.10.0.0 <--> 10.20.0.0 networks)

Slow is this: (capture from my acces log)

10.10.0.90 - phelki [28/Aug/2001:13:45:00 +0200] "phelsinkiGET /puustelli/FMPro?-db=a2ktfdfdvid.fp5&-lay=nettisivusto&-format=lista.htm&-SortField=sukunimi&puustelli%20poistaa==&puustelli%20aktiivinen=1&puustelli%20tunnus%20netti=phelsinki&-So rtOrder=Ascending&-max=1500&-Error=errors.htm&-find HTTP/1.1" 200 1787580

10.10.0.90 - phelki [28/Aug/2001:13:46:11 +0200] "phelsinkiGET /puustelli/FMPro?-db=t2ilauerrsa.fp5&-lay=nettisivusto&-format=lista2.htm&-SortField=sukunimi&puustelli%20poistaa==&puustelli%20kasittelee==&puustelli%20aktiivinen=1&tilaan=puustel li%20tarjouspyynt

[Keith M. Davie]

"Problems with one over 30 000 record database... (too many thing to do too litle time ) So, how to speed up it?"

Look to your database structure first.

30,000 records can take some time, especially when performing a find. The amount of data in the field being searched can adversly affect the speed of the find. Performing a find on more than one field adds to the complexity and thus the time involved. If the other fields contain complex data, that will slow the process even more. Sometimes it is possible to create other fields specifically for performing finds and which fields may contain just one bit of data (as for instance a single letter or two letters) on which to perform a find. If calculations are involved, make sure they are unstored.

As to the code you have published, I have simply put line-breaks to discern your code more easily. Your file names are very long.

/puustelli/FMPro?-db=a2ktfdfdvid.fp5

&-lay=nettisivusto

&-format=lista.htm

&-SortField=sukunimi

&puustelli%20poistaa== <!---I believe this is part of the problem-->

&puustelli%20aktiivinen=1

&puustelli%20tunnus%20netti=phelsinki

&-SortOrder=Ascending

&-max=1500

&-Error=errors.htm

&-find

Why are you searching for all fields which contain no data? Can't you find a better way to do this?

/puustelli/FMPro?-db=t2ilauerrsa.fp5

&-lay=nettisivusto

&-format=lista2.htm

&-SortField=sukunimi

&puustelli%20poistaa== <!---I believe this is part of the problem-->

&puustelli%20kasittelee== <!---I believe this is part of the problem-->

&puustelli%20aktiivinen=1&tilaan=puustel

Now you have added the complexity of performing a find on two fields which contain no data. Very cumbersome. Can't you find a better way to do this?

[Vaughan]

Change -max=50 and watch it speed up dramatically: FMP will find the first fifty, sort them, then return the results to the browser. Everything happens quicker so more things can happen in the same peroid of time.

[Anatoli]

RE: &-max=1500 and sort.

This &-max=1500 is plain ridiculous.

Sort is always the slowest part. But serving long list is also slow

Find on index field is always fast.

Dual Pentium would not help FM Unlimited much. Go for faster processor and SCSI disks on server and FM clients.

HW firewalls are faster than software ones.

Lot of depends on LAN/Firewalls tuning.

[timolous]

I tryed Different options. Here's what I explored.

1779499 - original time of finding

1790089 - changed one Field to 0,1

1775969 - No sort at all!! unexpected!

1748435 - No sort and 1 field less on find

1762555 - One field less on finding

So Anyting help not much at all... I all so tryed -max=50 etc.... I allready knew that it would be faster. But I need for my solution that every record is displayed on same page (even tought page becoms quite big).

[andrewbennett]

I've had much the same problems recently.

We have a 12,000 record database running under FM4.1 on a PIII 600. Our internal users access it through a web front end, even though they weren't being properly displayed.

Last weekend I did 3 hours worth of investigation about why it's so slow.

A user does a search which results in 150 records. This search takes the FM4.1 server around 2 seconds.

To transfer this list from the server to the web interface takes an additional 16 seconds!

I thought maybe it was the HTML construction of the display of the records which was taking the extra time, so I removed everything between:

[fmp-record]

and

[/fmp-record]

and it still took 14+ seconds to transfer the 150 records to the web front-end.

So...my question is...how does I speed this transfer up? I could use a faster machine for the server, but it won't get much much faster.

Any suggestions?

Thanks

-Andrew

[ September 01, 2001: Message edited by: AndrewB ]

[Keith M. Davie]

"To transfer this list from the server to the web interface takes an additional 16 seconds!"

Instead of displaying all records, try a combination of -max=15 and the next / previous feautre.

As far as the search, see if there is a different way to construct that for which you are searching, such that you may decide to classify records in a different manner through calculation fields or an common auto-look-up or some such. As they say at Apple, (owner of FMI) "Think Different".

[Anatoli]

RE: ... and it still took 14+ seconds to transfer the 150 records to the web front-end.

Hmm, I never come across such big records or such slow network.

In any case, I've found FM 5 Unlimited 5-8 times faster on web and FM 5 Pro opening files from FM5 server also 3-5 times faster.