Making Revolution faster with really big arrays

[Frank D. Engel, Jr.]

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

I haven't actually tried it with this type of algorithm, so I really 
don't know, and I've already deleted the eMail with the sample code; 
you'd need to send that code out again for me to even try testing it 
for you.

The docs for pl/pgsql are part of the standard PostgreSQL docs on their 
web site.


On Apr 28, 2005, at 7:55 AM, Dennis Brown wrote:

> 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
>>
>
> _______________________________________________
> 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)

iD8DBQFCcPCh7aqtWrR9cZoRArEPAJwPHbNQwyQrB9tjgYafbgBNJGgD0ACfZtJ5
insu3ilsQFOP1YzigsGenJw=
=7UAW
-----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