Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Webmaster Zone > Web Development
Register

Reply
 
LinkBack Thread Tools
Old 02.10.2002, 16:24   #1
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Post 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?
Reply With Quote
Old 02.10.2002, 17:38   #2
Школьник
 
Join Date: 04 2002
Location: Vanadzor
Posts: 227
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Post

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.
Reply With Quote
Old 02.10.2002, 17:52   #3
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Post

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%')";
Reply With Quote
Old 03.10.2002, 19:23   #4
Школьник
 
Join Date: 04 2002
Location: Vanadzor
Posts: 227
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Post

porcecir et zapros@ command lineic tas?

hastat mysql-n a tkum.

mi hat porci u asa.
Reply With Quote
Old 03.10.2002, 19:57   #5
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Post

Ha porceci
MySQL-na tqum.
Reply With Quote
Old 03.10.2002, 20:17   #6
Школьник
 
Join Date: 04 2002
Location: Vanadzor
Posts: 227
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Post

de inch asem Aram jan, pti princip@ poxes poiski.
Reply With Quote
Old 03.10.2002, 21:02   #7
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Post

Ba es et dzev txa em, vor im principnerin davachanem?
Whatever, thanks for comments.
Reply With Quote
Old 06.10.2002, 04:44   #8
Волк, просто волк...
 
_ WOLF _'s Avatar
 
Join Date: 07 2002
Location: /dev/null
Age: 72
Posts: 250
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Post

Ar, UNIX-i tak pordzel es ashxatacnes scriptd u nayes te inch resursner a utum??
Reply With Quote
Old 10.01.2005, 15:01   #9
Профессор
 
Nikita's Avatar
 
Join Date: 01 2005
Location: Perm
Age: 38
Posts: 2,142
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

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
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 16:07.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.