kolbasa reinckarnaziya - itogo
Apr. 10th, 2005 02:03 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
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...
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...
no subject
Date: 2005-04-09 05:18 pm (UTC)