Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Benchmarks for VFP versus SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00485384
Message ID:
00486647
Vues:
13
>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"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform