As we don’t know what is in the array, we use arrays of variants. This involves using dictionaries for the objects and Xojo arrays for the arrays in JSON. You can convert from Xojo objects to JSON and back. I didn’t try to work in a array with Prime as value, because I would have to store this value and I’m afraid it would be time and Memory consuming. For the upcoming 19.2 release, we’ll add new convert methods to our class. Now, is there a way to accelerate the search in the array ? Or another way to store Primes? I would prefer not to use DB, because I’m not familiar with SQL. To enumerate such collections, we recommend following workaround: Create an instance of ElasticVector Collection object, and call its AddRange Method, passing. This works fine, but between 100 million and 1 billion, this becomes drastically slow. So I have to loop until finding the xth Prime, ignoring rows with False values. A call to a method or function that has been declared using ParamArray uses a comma-delimited list of values rather than an array. 1 billion rows → 50 847 534 Primes in 66,11 secondsīut then, searching a Prime in the array is very slow, because the Prime is not the value of a row, but the index.I’ve coded a Sieve of Eratosthene, using an array of false Boolean, and I set up the boolean to True when finding a Prime. The goal is to calculate Prime numbers, as fast and as much as possible. If the returned value contains a Dictionary, it. In the use case I was most interested in at the time, I had a set of about 100 strings with an average length of 20 characters, and for that case the dictionary was dramatically faster (>30X) than a brute force search through the array. You could have multi dimensional arrays that store a column of data in each dimension. I benchmarked the old dictionary vs array several years ago and my data was similar to Norm’s. Arrays are great for storing an ordered set of data. A dictionary is really a lookup table that ends up being very fast and flexible. A dictionary can be used in a sense like an array but it’s different. Parses JSON text and returns it as an Auto, which will typically contain a, an array of Dictionaries or an array of primitive data types (Integer, Text, etc.) depending on the JSON text. A dictionary can have way more than two items in it. Yes, Kem, you’re right, it’s a challenge! Supported for all project types and targets. Ok, I see I have to give you more details.

Xojo dictionary of arrays