Quote:
Originally posted by Mark Hensler
I'm not sure about mySQL load for mysql_fetch_array() vs mysql_fetch_row(), but the fetch_array will take up more memory (not much).
What is the hack for?
How often will this be run?
[...]
|
Well. I was trying to do myself an enhanced user moderation queue, mainly to findout potential dupe users when moderating new ones.
You can check
here the original input, but would try to solve myself as far as i could.
By now I added a new action to
admin/user.php like 'finddupe', called from the user moderation page.
Actually I would need to load in memory almost 3-4 columns of the user table as I should compare the single
metaphone() each others, measuring the
levenshtein() distance between, for example, usernames/emails/ips/password-md5-hash (identical, of course), and so on.
This reason I though to memory as mySQL couldn't do anything itself.
Frequency: well, about once/twice a day, the times I moderate new users...
Do you think an array like this should overload the system ?
P.S.: anyway, any 2D arrays example ??? :supwink:
Thanks, poet!!! :china: