How to get the difference between two lists?

[Frank D. Engel, Jr.]

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

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