robinbobin ([personal profile] robinbobin) wrote2005-04-10 02:03 am

kolbasa reinckarnaziya - itogo

sama kolbasa - fignya

no zato naucilsya (?) optimizirovat server/scripts/db

1. sdelal tak, shoby
a) po zaprosu user.gif, (kotorogo netu), t.e. po 404 handleru, request uletal na lighttpd, v kotorom dobavil mod_cgi na php)
b) sam scipt perepisal pod cgi
c) shoby ne teryat HTTP_REFERER, parsing parametov proizvodiysa v handlere i vyzov otobrazhatelya idet vrode kak obychno script.php?user=shmuzer&et

2. db
1. bylo: owner i friend unequal indexed.
ubral nax.
2. bylo
$sql = "REPLACE DELAYED lj_users
SET Owner = '$owner',
Friend = '$user'";
stalo:
$sql = "INSERT lj_users
SET Owner = '$owner',
Friend = '$user' ";

kak by ono ne bylo... no server zhivet..
xotya...