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 [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
