-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
If the DB is properly indexed, there is no way that Transcript should be able to perform that kind of sort faster than the DB server. An SQL server should be able to use an index to perform that kind of sort substantially faster than it could be done by a generic sorting algorithm, such as what Rev would need to use with its 'sort' command.
The only major exception is when the client is distributed among multiple computers (different people accessing the server simultaneously with the client on separate machines per user) and the database server is on hardware which is being very heavily used. In this case, the client may be able to sort the incoming data faster than the DB can, only due to the server being slowed down by a heavy processing load of multiple other users. However, there would need to be a rather extreme number of users for a correctly indexed database to slow down to this point, at least with a query like that one, since the index should allow the server to just read off the needed data in a sorted order to begin with, rather than needing to take any extra steps to sort it at all. Complex views might complicate the matter somewhat, but last time I checked, MySQL did not support views (a somewhat strange omission for such a popular db server...)
On Apr 4, 2005, at 4:40 PM, Trevor DeVore wrote:
Do you mean that the transcript sorting code executes faster than the mySQL doing the sorting (with something like 'SELECT ID, FirstName, LastName FROM people ORDER BY LastName') or that it is just easier for you to handle everything in transcript rather than figuring out the SQL syntax to perform some of the sorts, joins, etc.?
- ----------------------------------------------------------- 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)
iD8DBQFCUaiE7aqtWrR9cZoRAmPVAKCRLmyw301tHZCVzVhcMaM+uICS3gCfV2x7 uYM3tgGMtRwDDHAQvizbhmc= =sJMT -----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
