slow performance

[daviator]

I'm sharing a Filemaker database on my small intranet via web companion. However, submitting a record takes forever (5-10 minutes). The server is an NT box running Filemaker and the workstations are connected via 100MPS cards. No other apps have issues running over the network.

Any ideas would be greatly appreciated.

[Keith M. Davie]

Are you using Instant Web Publishing?

[daviator]

No. I've created the pages using the wizard found in the now defunct Claris Home page. The Instant Web Publishing thing won't allow me to run scripts and limits my design ability.

[Keith M. Davie]

There have been many cautions on these forums against running scripts in a browser solution. If one of your scripts involves a loop, that is probably the cause of your slowness problem.

If you have a looping script, you may want to examine my recent postings on the cdml forum regarding the looping script. I have provided code and structure for you to experiment with a looping script as well as a multi-user request on a script or scripts.

[daviator]

Thanks Keith,

No looping script but I found my problem. My script sends an email when the record is submitted and I forgot to start my email client on my server Duh.

Thanks,

Dave

[Vaughan]

Don't use a script for that... put the -mailto, -mailsub, -mailformat etc CDML codes in your format field and get web companion to processa nd send the e-mail directly.

The less scripts that run the better, but it also gets one extra application off your server, which IMHO is even better. Also the Send Mail step doesn't support many mail clients, and the mail clients have to set to automatically send mail on check to work... complicated eh?

[daviator]

Hi Vaughan,

But how could i get it to mail to the name selected from a drop-down list?

Thanks,

Dave

[Vaughan]

The submit process the selected address. That is, they select the address from the list then click the button. (Somebody might suggest a java auto-submit of some description too.)

It can be done, try it and work the process through.

[Tyfud]

Following Vaughan's reply. Check out http://www.filemaker.com/support/techinfo.htm

do a search for Tech info article number "106018" This gives two possibilities over the web (there is a third with the oprn URL script step but these are the best two.