Thierry,
What is the best way to work with ODBC connections in foxincloud? In my tests I noticed that only an active connection is left, even using the system in several machines. In production mode does this change?
This is how Gilles (in vacation, reason why I answer for him) manages postGreSQL connections:
procedure xxxSets.Init
_SCREEN._gnconnect = SQLSTRINGCONNECT(m.cConnectString, .T.)
procedure someForm.Load
=open_dbc()
USE v_entete IN 0 NODATA AGAIN CONNSTRING(_SCREEN._gnconnect) SHARED
USE v_variable IN 0 NODATA AGAIN CONNSTRING(_SCREEN._gnconnect) SHARED
USE v_transmet IN 0 NODATA AGAIN CONNSTRING(_SCREEN._gnconnect) SHARED
…
each server instance has a single shared connection
this app runs 6 server instances for 35 concurrent users
I understood. How do I simulate the production environment, to know if it will work as needed?
The only difference between development and production is the connection string
nothing else changes
Gilles has no progressive fetching; if you have some, you'll probably need connection(s) dedicated to these views; all the other views can share the same connection.
OK! I have great curiosity without knowing how FoxInCloud behaves if 50 machines have different records recorded on a single table. Will one machine need to wait for the other? How are the reports? Because in some tests I did one machine had to wait to finish generating another to continue processing. I do not know if you can understand me.
What do you mean by ‘machine’: client or server?
On server side, you can multiple FoxinCloud ‘logical’ server (COM objects in production). Web connect’s dll directs an incoming request to the first idle server. If all servers are busy and request times out you get a message and just add another couple of logical servers.
Once you have the proper count of servzrs, users never contend for server time.
When I say machine, I mean client, I'm sorry. I understood your explanations, how can I test this? I know little about the production environment.
how can I test this?
You can run several instances of your app server (1) on your dev machine and access it from several browsers on the same or on other machines through the LAN (2).
(1) 3 ways to do that:
- open several instances of FoxInCloud Web App studio (desktop shortcut) and, in each,
do xxxTest.prg
build exe xxxTest from xxxTest
and run several instances ofxxxTest.exe
from within Windows Explorer- set in
…\site\xxxTest\bin\wc.ini
:
Server1=xxxTest.xxxServerTest
Server2=xxxTest.xxxServerTest
…
and hithttp://localhost/xxxTest/wc.wc?_maintain~SetAutoMechanism
to turn your app in COM mode, the same you'll use in production.
Whenever you hit http://localhost/xxxTest/
, the number of servers set above will start;
you should see the server windows pop up in the Windows desktop; if not please feedback, there must by a wrong setting
(2) using http://192.168.x.y/xxxTest/
; make sure the Windows firewall on the development machine accepts incoming http requests.
I know little about the production environment
Then maybe we need to organize a production workshop 😉
Right! To test this, I'll need more west wind licenses, correct? From FoxInCloud I am entitled to 10 simultaneous accesses. Right?
You can do all I described without any additional license (see 'Licensing' near the bottom)
FoxInCloud I am entitled to 10 simultaneous accesses. Right?
Right however only if you have continuously more than 10 Concurrently Active Sessions
, you receive an email from us to let you choose a license extension; you app does not stop working.
Yes, but in the table that is in the site only it is stated that I have only a license of the West Wind. Can I simulate 5 servers of it without having the license only for tests?
Hi Arcadio if you test your foxincloud application with 1 to 32 wwc servers instances in the same PC, (one machine), only one wwc licence is neaded.
Regards Gilles
Hello, Gilles,
OK! If it is to be put into production after the tests, then I have to acquire the licenses, correct? Would the configuration be the same?
1 WW license per production server computer
Hello Arcadio,
The configuration will be the same since the fulls paths are all the sames.. Somes details must be differents in the xxx.ini like: LicenseAdmin = xxxxxxx LicenseAdminEmail = xxx@yyy.zzz LicenseAdminPW = *****
Regards
I could not, I probably should have some wrong configuration. Displays this message below.
Unable to load servers We're performing maintanence operations. Please check back in a few minutes.
If I could shoot a video with these steps, it would be great.
Unable to load servers We're performing maintanence operations. Please check back in a few minutes.
If you hit http://localhost/xxxTest/wc.wc?_maintain~ShowStatus
, you should see this:
Load servers by hitting http://localhost/xxxTest/wc.wc?_maintain~Load
3 ways to do that:
1 open several instances of FoxInCloud Web App studio (desktop shortcut) and, in >each, do xxxTest.prg
2 build exe xxxTest from xxxTest and run several instances of xxxTest.exe from >within Windows Explorer
3 set in …\site\xxxTest\bin\wc.ini: Server1=xxxTest.xxxServerTest Server2=xxxTest.xxxServerTest
Is step 1 and step 2 necessary? Or just step 1 or only step 2?
You can pick any of the 3 ways… same result with different methods
Step 2
What about step 1? does it work?