Making Revolution faster with really big arrays

[Frank D. Engel, Jr.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try PostgreSQL, which offers stored procedures.  You could write the 
complex parts of the algorithms in pl/pgsql, if nothing else -- or 
pl/perl, or pl/python, or whatever.

On Apr 27, 2005, at 12:07 PM, Dennis Brown wrote:

> 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
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFCcBSo7aqtWrR9cZoRAqPNAJwNlnoWWFlDlFUkH8iN5flftEyl+wCggQXb
nYgvMmE+WiguK14yohNJ/W4=
=ywu1
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 200MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com