Good morning everybody. I developed a system for the NZ Police for criminal profiling in Rbase 6.5+ This system is going into its 8th year and was originally written as a small system in 1994 with Rbase 4.5.
The database consists now of 46 tables with 310 fields. We have currently loaded 11,743,000 records. One table contains slightly over 4,000,000 records. We tried to add extra data and noticed that the system stops after loading an additional 470,000 records (approximately). Apart from the fact that this is hindering an important piece of work, we are currently loading an additional 30 - 40,000 records to the database each month, which implies that we would be running out of space within the next year. Is there a capacity limit within Rbase? Is Oterro a viable alternative? Or should we go to something like mySQL and use Rbase as a front end through ODBC? Thanks Frank van der Zwaag ____________________________________________________________________ CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Air New Zealand immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Air New Zealand. _____________________________________________________________________ For more information on the Air New Zealand Group, visit us online at http://www.airnewzealand.com _____________________________________________________________________
