Daniele, I see I didn't word my question very well.
Try connecting one computer to the database, and run your routine. Leave the first computer connected, connect a second, and run the same procedure from the first computer. Connect a third. Run the same procedure from the first machine again, etc. If merely connecting additional computers to the database slows the procedure, there is probably a file locking issue on the server. If that is the case you will see a big drop in performance after connecting the second computer to the shared database, not much change after that. If you only see a performance hit when all your machines are actively using your procedure then I could imagine any of several issues. Ben On Mon, Oct 24, 2011 at 2:24 AM, Daniele Barbieri <[email protected]> wrote: > Hello All... > > Request for help > > We are having serious problems with a procedure carried out with R:BASE 6.5, > installed on a server and used by several PCs (8-10) at the same time. The > server response times are extremely long and it is impossible to work with > more than 2-3 PCs simultaneously. > > Here is our scenario: > > 1) The server is a PC Proliant ml110 g6 processor i3 2g ram with raid 1 > configuration with sata disks > > Operating system: Windows 2008 server 32bit > > 2) Local network: 6 10/100/1000 MHz > > 3) The PCs are all dual core 2.0 GHz with 2G ram in Windows XP. > > 4) On the server C: disk, the R:BASE procedure is contained in a folder > (C:\ELVIS) "shared in the network" with the startup file RBASE.DAT and > MULTIUSER ON > > 5) Every PC has installed RUNTIME 6.5 and accesses the server via "shared > resources" of Windows XP. The folder C:\ELVIS is shared and it is "seen" by > the PC and RUNTIME as unit X: > > > > Questions: > > a) Is there a way to make the procedure faster even with 10 PCs connected > simultaneously? > > b) Can a change from procedure R:BASE-6.5 to R:BASE-9.1, keeping the same > scenario unaltered, solve the problem? > > > > Thanking you in advance for your support, > > I send my best regards. > > > > Daniele Barbieri > B.M.B. Informatica > --- RBASE-L > ================================================ > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > ================================================ > TO UNSUBSCRIBE: Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > ================================================ > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, place any text to > search for. > ================================================ > > >
