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 [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
- ----------------------------------------------------------- Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ 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 [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
