Making Revolution faster with really big arrays

[Dennis Brown]

Frank,

That sounds interesting.  How fast can PostgreSQL generate the simple 
example I showed using an item by item algorithm?  Will it really 
execute faster than Transcript?

Dennis
On Apr 27, 2005, at 6:39 PM, Frank D. Engel, Jr. wrote:

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