The question is what kind of procedures you are talking about. Is it just 1 procedure which updates the same tables and if so did you check the settings like rowlock? Did you check PK. FK's and other indexes? It is a long time ago I have worked with 6.5, but in my memory the performance was always ok, even it was heavily used.
9.1 definitely offers more possibilities, but as always don't expect miracles just by converting the old database to the new one. If you like to gain performance you should make use of the possibilities of 9.1 (like temporary tables and so on) and that will take time. If you consider to move to 9.1 I recommend the 64 bits version and in your case I would also consider to buy the compiler. This compiler offers you the possibility to store the forms, reports and so on in the compiled program itself. It makes it very flexible Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Daniele Barbieri Sent: maandag 24 oktober 2011 11:24 To: RBASE-L Mailing List Subject: [RBASE-L] - Request for HELP 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
