Jump to content

RAIC & Scripts...


This topic is 7305 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Has anyone tried running a "-script" tag on a FMP RAIC server system that has multipe machines serving the DB that the script is from.

If a set of DB's is hosted on a machine running FMP Server, and 5 other machines are clients to that server, which are then "sharing" those same DBs with an Apache server running WSC does the actual "running" of the script take place on the 5 'client' machines or on the Server? Or Both?

The big question is would it be possible to access _other_ data (not another script) in the same DB that a script was being run from IF it were on a different one of these clients?


Link to comment
Share on other sites

The script will run on first available machine. And then what? When next visitor get allocated to the same machine with anything, the last result from script will be gone...

I still did not found the need for scripts. What so marvelous will script achieve and HTML page not?

Link to comment
Share on other sites

I've got a scheduled script that pulls email from a POP account into a DB, and then I need to access portions of that email (subject for example) via the web.

So the web user does not need to actually "RUN" the script, just access the data AFTER the script has finished.

It doesn't mater if the web user gets the "latest" data from these emails, as long as their request isn't stopping the script from downloading the messages. (mail is downloaded every 10 mins or so, and takes aprox 15-20 seconds)

So I was thinking that a RAIC might solve my problem if while the script was executing (ie getting the email) the web requests were handled by other machines all serving data from the same DB hosted by FM Server.

The big questions is, will these web requests still be able to access the data? Or will they have to wait for the script to finish (or worse interupt it) even though the script is actually being executed by a client machine that is also sharing the DB?


Link to comment
Share on other sites

My best guess is that machine which will respond first will get the job.

Otherwise, it should work. Usually the script is cancelled by request only when it is in PAUSE stage. Otherwise the machine will be busy and connector will call another Unlimited to work.

IMHO, best will be to let standard FM to update the files on server, not Unlimited serving web.

The records added to server will be immediately available to the clients. By adding I mean when FM server will create record, populate it with data and update the indexes if they are any.

Link to comment
Share on other sites

That's excellent Anatoli!

I hadn't thought of using a "standard" FMP to do the 'script' work...

That way there would be NO opportunity for a web request to be hindered in any way!!

And I've got an 'extra' standard copy of FMP 5 that came with Developer!

That saves me about $999 for that 'extra' copy of Unlimited!

I'll give that a try, and let you know how it works out (my FMP Server is supposed to arrive tomorrow).


Link to comment
Share on other sites

This topic is 7305 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By cREX
      Is there any limitation as to how many databases I can have opened at the same time (connected to the web)?
    • By Udaryls
      Can we use FMU as a back end and have our users put the HTML on a Linux webserver running Apache?
    • By mikel
      perhaps a really stupid problem:
      FileMaker unlimited is online. Web companion is running ok. everything works over a browser.
      But now we want to directly open the database with another filemaker via TCP/IP from another place via web.
      By clicking "hosts" an putting the IP-Adress, no connection can be built.
      A Ping works correctly.
      Is there a solution :
      Thank U
    • By MTGriz
      Anyone else have this happen to them? Running an NT 4 sp6a box (256 MB RAMM, dual Celeron 400s) with FMPro 5 Unlimited, Web Connector to IIS SSL, Web Companion, and every week or so the FMPro quits on me. The app. has 9999k cache and is set to save every hour or when necessary. Any guesses at the problem? Don't think it is hardware ...
    • By cmbhatt
      I would like to install FM Pro 5 and FM pro unlimmited on 1 box. However, I want to only use the FM pro Unlimited for the web companant. Is this possible? If it isn't why wouldn't it, since only thing is being used is the FM Pro unlimited web componant.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.