Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Benchmarks for VFP versus SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00485384
Message ID:
00486647
Views:
14
>The workstation writes a one record DBF (each field represents a single parameter) with .REQ extension into certain directory on the server and goes into the DO WHILE loop (with the timeout), waiting for the result DBF with the same name and .DBF extension to appear in the same directory.
>
>FoxPro server is actually a PRG with DO WHILE loop, constantly looking for the .REQ files to appear. When it finds one, it grabs it, stores the parameters from fields into memory variables and immediately deletes the file.
>
>Then it calls the calculation module. All the processing is done on the cursors in memory. When the calculation module creates a result cursor, it returns the control to the FoxPro server. FoxPro server copies the cursor to the DBF with
>COPY TO (request_file_name + ".DBF")
>and shows the execution time on screen.
>
>As soon as the result DBF appears in the directory, the client wakes up, grabs the result DBF into it's own cursor and deletes the DBF.
>If it didn't get the result DBF in, say 10 sec, it just asks the user to try again later.

Thanks Nick,

So your client is also in a loop waiting for a (request_file_name+".dbf") to appear in that shared dir? Are you using a DO WHILE loop too?
How well is this solution handling multiple concurrent requests/responses?

...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....                       

...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
 

Ismael Rivera "Oye cosita linda"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform