How to get the difference between two lists?
Frank D. Engel, Jr.
fde101 at fjrhome.net
Mon Apr 4 16:50:12 EDT 2005
-----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
More information about the use-livecode
mailing list