PHP Problem

Aram Ghazanchyan · Oct 2, 2002, 15:24

U menya komp PIV 1600, 512 RAM
Systema Win 2000 Advanced Server.
Pod IIS postavil MySQL i PHP.
Na php napisal poisk po baze, baza ne takaya uzh i bol'shaya, no kak tol'ko delayu submit formy, CPU dostigaetsya 100%, otkryvayu Task Manager, php.exe syedaet 300-400 Mb RAM-a.
Mozhet vy stalkivalis' s problemoj takogo roda?

strax. · Oct 2, 2002, 16:38

de ete asum es PHP.exe-n a urem@ kodt a vat grac. ete karas gci nayenk.

bayc indz chi tvum vor kodic a, porci mi hat et zapros@ commandni strokaic tas, u kjoges php-i problemn a te mysql-i.

Aram Ghazanchyan · Oct 2, 2002, 16:52

Es unem mi hat glxavor table "projects"
u unem mi qani table, voronq kaxvac en et projects table-i ID-ic, u iranc mot pahum en ProjectID fieldum konkret projecti ID-n.
Zapros@ hetevyalna

$query = "SELECT project.ID, project.Name FROM project, project_location, project_healthcare, project_activity WHERE project.ID=project_location.ProjectID and project.ID=project_healthcare.ProjectID and project.ID=project_activity.ProjectID";

de heto el @st locationi, healthcare-i u activity-i parametreri search em anum.

if ($Region) $query .= " and (project_location.Marz LIKE '%$Region%' OR project_location.Town LIKE '%$Region%')";

strax. · Oct 3, 2002, 18:23

porcecir et zapros@ command lineic tas?

hastat mysql-n a tkum.

mi hat porci u asa.

Aram Ghazanchyan · Oct 3, 2002, 18:57

Ha porceci
MySQL-na tqum.

strax. · Oct 3, 2002, 19:17

de inch asem Aram jan, pti princip@ poxes poiski.

Aram Ghazanchyan · Oct 3, 2002, 20:02

Ba es et dzev txa em, vor im principnerin davachanem?

Whatever, thanks for comments.

_ WOLF _ · Oct 6, 2002, 03:44

Ar, UNIX-i tak pordzel es ashxatacnes scriptd u nayes te inch resursner a utum??

Nikita · Jan 10, 2005, 14:01

a tablici imeyut Key-i
i proboval organizovivat` poisk opirayas` na nix ?
u menya select po tablice bez klyuchey zanimal okolo 30 sec
a s key-em men`she sekundi

Oct 2, 2002, 15:24	#1
Aram Ghazanchyan Web developer Join Date: Sep 2002 Location: Yerevan Posts: 885 Rep Power: 7 Reputation: 14	PHP Problem U menya komp PIV 1600, 512 RAM Systema Win 2000 Advanced Server. Pod IIS postavil MySQL i PHP. Na php napisal poisk po baze, baza ne takaya uzh i bol'shaya, no kak tol'ko delayu submit formy, CPU dostigaetsya 100%, otkryvayu Task Manager, php.exe syedaet 300-400 Mb RAM-a. Mozhet vy stalkivalis' s problemoj takogo roda?

Oct 6, 2002, 03:44	#8
_ WOLF _ Волк, просто волк... Join Date: Jul 2002 Location: /dev/null Posts: 250 Rep Power: 7 Reputation: 10	Ar, UNIX-i tak pordzel es ashxatacnes scriptd u nayes te inch resursner a utum?? __________________ 00000000h: 41 72 61 6D 20 4D 6B 68 69 74 61 72 79 61 6E;

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Oct 2, 2002, 16:38	#2
strax. Школьник Join Date: Apr 2002 Location: Vanadzor Posts: 227 Rep Power: 7 Reputation: 10	de ete asum es PHP.exe-n a urem@ kodt a vat grac. ete karas gci nayenk. bayc indz chi tvum vor kodic a, porci mi hat et zapros@ commandni strokaic tas, u kjoges php-i problemn a te mysql-i.

Oct 2, 2002, 16:52	#3
Aram Ghazanchyan Web developer Join Date: Sep 2002 Location: Yerevan Posts: 885 Rep Power: 7 Reputation: 14	Es unem mi hat glxavor table "projects" u unem mi qani table, voronq kaxvac en et projects table-i ID-ic, u iranc mot pahum en ProjectID fieldum konkret projecti ID-n. Zapros@ hetevyalna $query = "SELECT project.ID, project.Name FROM project, project_location, project_healthcare, project_activity WHERE project.ID=project_location.ProjectID and project.ID=project_healthcare.ProjectID and project.ID=project_activity.ProjectID"; de heto el @st locationi, healthcare-i u activity-i parametreri search em anum. if ($Region) $query .= " and (project_location.Marz LIKE '%$Region%' OR project_location.Town LIKE '%$Region%')";

Oct 3, 2002, 18:23	#4
strax. Школьник Join Date: Apr 2002 Location: Vanadzor Posts: 227 Rep Power: 7 Reputation: 10	porcecir et zapros@ command lineic tas? hastat mysql-n a tkum. mi hat porci u asa.

Oct 3, 2002, 18:57	#5
Aram Ghazanchyan Web developer Join Date: Sep 2002 Location: Yerevan Posts: 885 Rep Power: 7 Reputation: 14	Ha porceci MySQL-na tqum.

Oct 3, 2002, 19:17	#6
strax. Школьник Join Date: Apr 2002 Location: Vanadzor Posts: 227 Rep Power: 7 Reputation: 10	de inch asem Aram jan, pti princip@ poxes poiski.

Oct 3, 2002, 20:02	#7
Aram Ghazanchyan Web developer Join Date: Sep 2002 Location: Yerevan Posts: 885 Rep Power: 7 Reputation: 14	Ba es et dzev txa em, vor im principnerin davachanem? Whatever, thanks for comments.

Jan 10, 2005, 14:01	#9
Nikita Профессор Join Date: Jan 2005 Location: Perm Posts: 2,142 Rep Power: 4 Reputation: 10	a tablici imeyut Key-i i proboval organizovivat` poisk opirayas` na nix ? u menya select po tablice bez klyuchey zanimal okolo 30 sec a s key-em men`she sekundi