Making Revolution faster with really big arrays

Dennis Brown see3d at writeme.com
Wed Apr 27 11:07:57 CDT 2005


Stephen,

The math I want to do is not regular --as in the simple example, but 
very algorithmic on a item by item basis.  The overhead of passing the 
data to and from MySQL will kill the speed unless it can do all the 
algorithms internally.  Previous attempts have shown this.

Dennis

On Apr 26, 2005, at 9:06 PM, Stephen Barncard wrote:

> MySQL can do math on columns like you want. Very Fast. No loops in 
> transcript.
> Check out the GROUP BY (Aggregate) Functions.
>
> http://dev.mysql.com/doc/mysql/en/group-by-functions.html
>
>
>
> At 8:06 PM -0400 4/26/05, Dennis Brown wrote:
>>
>>
>> Can anyone think of another way to do this that would be faster (for 
>> accessing parallel arrays, not the trivial adding them together 
>> operation I am doing here).  Of course the times are for my machine 
>> and will vary on yours, but the
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



More information about the use-livecode mailing list