problem with me or postgres ?
От | Fred J |
---|---|
Тема | problem with me or postgres ? |
Дата | |
Msg-id | 9g18sv$ae8$1@news.tht.net обсуждение исходный текст |
Ответы |
Re: problem with me or postgres ?
|
Список | pgsql-general |
Hi, I'm building a site based on linux/apache/PHP/Postgresql. (redhat7,apache 1.3/PHP4.04/Postgres 7.1) I have the following SQL on a PHP page that processes a rather complex search form. SELECT talent.*,models.* FROM talent join models on (models.usrindx=talent.indx) where validated=1 AND ( (av_runway=true) OR (av_fashion=true) OR (av_sport=true) OR (av_casual =true) OR (av_print =true) OR (av_swimwear =true) OR (av_lingerie =true) OR (av_glamour =true) OR (av_art =true) OR (av_nude =true) OR (av_erotic =true) OR (av_artisticnude =true) OR (av_acting =true) OR (av_tv =true) OR (av_adult =true) OR (av_film =true) OR (av_dancer =true) OR (av_stage =true) OR (av_adv =true) OR (av_livepromo =true)) AND haircolor ='Blond' AND hairlength ='Waist-length' I have about 25 records in table talent which has about forty columns i have 2 records in table models which has maybe 65 columns. the server will porcess sql without the last two AND clauses (eg without 'AND haircolor ='Blond' AND hairlength ='Waist-length' at the end) BUT pgsql generates a runaway process that loads up the server and fills the log file as fast as the server will fill it on the above sql. the log file if filled with blank lines?! over 4 gig of em in just a few minutes. any ideas? I expect the sql to grow by at least another 25 AND clauses. Is this sql too long? where would I look for docs specifying the length of an SQL statement? Thank You Fred
В списке pgsql-general по дате отправления: