01-24-2011 08:23 AM - edited 01-24-2011 08:23 AM
What is the maximum possible number of rows in a table. What happens when that number is exceeded?
01-24-2011 09:36 AM
The short answer is the amount of memory you have available. HOwever, using REALLY large tables can be very slow. You can help performance if you preallocate the array (a table is really just a 2D array) and use replace array subset to update it.
When faced with these types of issues you really need to ask yourself whether or not you need all of the data in memory at the same time or can you store it and work with it in chunks.
01-24-2011 12:19 PM
2,147,483,647
If you want to use any of the array functions that take an 32I as input to index an element of your array.
01-25-2011 07:18 AM
Omar and Mark are both correct. If you are using a large table, for performance reasons, you should buffer it in your program as a 2D array (preallocated, of course), and only put in the table what is actually visible at that time. Hide the table scrollbars and use external scrollbars to control it. If you need more help, let us know.