Alastair, The big difference in the 32 and 64 bit versions of Windows is that the 32 bit can address only 4GB of main memory (in reality 3.2 GB is usable) with a 2GB limit per application, while the 64 bit version can take as much memory as you can get. Obviously if the software is not optimized for 64 bits, there will be no difference and, if both systems have only 4Gb available, the 32 bit version might be faster since it uses less memory overhead. For programs optimized for 64 bits that use and have available lots of memory, the difference can be huge. If I understand correctly, and R:azzak can correct me if I am wrong, R:Base uses 64 bit pointers to access terabyte size databases compared to the 32 bit version limit of 2GB, and other size limits are also much larger; however, the software itself is not yet optimized for 64 bit. BTW, I did reach the limit of 80 computed columns per table for one application and I had to make some compromises; however, once I updated to the 64 bit version with its 400 computed column limit it was no longer an issue. Which version works best or is sufficient for your depends on the applications you have and the future upwards scalability you desire. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Wednesday, April 22, 2015 1:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: TALLY giving unexpected results Well, as far as I am concerned, nobody has ever made a case for moving – at some expense – to the 64bit version. Looking at the comparison table I still see nothing that would make a significant difference to my databases. Moreover, my memory is not what it once was, but I seem to remember the opposite case being made, that is, don’t change unless you need to for the longer names, etc. Am I right to assume that the 64bit version of R:Base is not yet adapted to take advantage of a 64bit operating system? An operating system that itself seems not to be a huge advantage over the 32bit version in any case. Nevertheless, that capability might be worthwhile as my current system came with 64bit Windows. Regards, Alastair. From: A. Razzak Memon <mailto:[email protected]> Sent: Wednesday, April 22, 2015 6:04 PM To: RBASE-L Mailing List <mailto:[email protected]> Subject: [RBASE-L] - Re: TALLY giving unexpected results At 12:21 PM 4/22/2015, Patty Buckingham wrote:
>Thank you for the reply. I am new to eXtreme 9.5 and have not >created a startup file >(nor can I find any files in my RBTI folders named *.cfg, if they >exist) so was not >able to edit RBENGINE95_32.CFG. > >The SHOW NAMEWIDTH command didn't work for me: > >R>SHOW NAMEWIDTH >-ERROR- Invalid parameter ( 639) > >I also struck out when trying to SET the namewidth: > >R>SET NAMEWIDTH 60 >-ERROR- This command is currently unsupported in R:BASE V-9 (32-bit) >version . (3222) > >Any other suggestions? Aha ... I didn't know that you are using R:BASE eXtreme 9.5 (32). I wonder why folks are still using 9.5 (32), unless you are stuck and are having difficulties migrating your .RB? databases and applications to 9.5 (64) .RX?, or still using the same .RB? database with R:BASE 9.5 for DOS. For the record, there are sooooooooo many advantages to using R:BASE eXtreme 9.5 (64). http://www.rbase.com/rbg95/compare.php Converting from R:BASE eXtreme 9.5 (32) .RB? to R:BASE eXtreme 9.5 (64) .RX? is as easy as 1-2-3. In any case, NAMEWIDTH setting is eXclusively for R:BASE eXtreme 9.5 (64). With the default installation of R:BASE eXtreme 9.5 (32/64), you may find the R:BASE configuration file under the C:\Windows RBENGINE95_32.CFG RBENGINE95_64.CFG In your specific circumstances, you could use the following options to obtain the correct display of your TALLY command: 01. Use the Data Browser to View the results of TALLY command BROWSE ColumnName FROM TableorViewName WHERE ... Click on the column and then right-click to select Calculate and then TALLY 02. Database Explorer | Tables | Open Table ... Click on the column and then right-click to select Calculate and then TALLY 03. Database Explorer | Tables | Open Table ... Main Menu | Calculate | TALLY .... Hope that helps! Very Best R:egards, Razzak www.rbase.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
