[Aram Ghazanchyan]

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.]

de ete asum es PHP.exe-n a [email protected] kodt a vat grac. ete karas gci nayenk.

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

[Aram Ghazanchyan]

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.
[email protected] 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.]

porcecir et [email protected] command lineic tas?

hastat mysql-n a tkum.

mi hat porci u asa.

[Aram Ghazanchyan]

Ha porceci
MySQL-na tqum.

[strax.]

de inch asem Aram jan, pti [email protected] poxes poiski.

[Aram Ghazanchyan]

Ba es et dzev txa em, vor im principnerin davachanem?
Whatever, thanks for comments.

[_ WOLF _]

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

[Nikita]

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