CAcert Code Development list.

[dirk astrath <dastrath AT gmx.de>]

hiya,

At the beginning of last week i had an email-discussion to Alexander
according to the 'my points'-statistic ...

He sent me a patch to speed up this statistic ... and I ran it on my own
test-system (with a database three times as big as it is at CAcert).

The time-difference is enormous ... 60 seconds the old routine, less
then 10 seconds the new one ... ;-)

I copied the file /pages/wot/10.php to test1.cacert.at ...

However ... i added the file to this mail ... ;-)

For explanation:

There are two clauses missing in the new SQL-command:

(a)     Comparison between notary.from and notary.to
(b)     'order by notary.when'

The (a)-part should not be necessary, since you can't assure yourself.
The (b)-part is necessary only, when there is the same number of
assurances to list the 'earlier' assurances on the 'higher' place ...

Since both parts costs a lot of time on the machine, we shouldn't care
about the 'correct' order for the place and speed up the listing (...
and therefore have a better performance on the system) ...

Thanks to Alexander for the patch!

have a nice day ...

Attachment: 10.php
Description: application/httpd-php

Attachment: signature.asc
Description: OpenPGP digital signature