Author: Circum
Email: [EMAIL PROTECTED]
Message:
Hi all,
When I am executing the '.../search.cgi?q=teszt&t=01' query, it results in the
following SQL queries:
11 Connect root@localhost on mnoGoSearch
11 Query SELECT url_id,intag FROM dict WHERE word='teszt'
11 Query SELECT
rec_id,url,content_type,last_mod_time,title,txt,docsize,next_index_time,referrer,keywords,description,crc32,tag,category,lang,charset
FROM url WHERE rec_id IN (1,2,3,4,5,6) ORDER BY rec_id
11 Query SELECT
rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=1096853705 AND
(status=200 OR status=304 OR status=206)
11 Query SELECT rec_id,path,link,name FROM categories WHERE
path=''
11 Query SELECT
rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=-1874676483 AND
(status=200 OR status=304 OR status=206)
11 Query SELECT rec_id,path,link,name FROM categories WHERE
path=''
[... the two queries above 4 more times with the other crc32's ...]
11 Quit
Questions:
1. Where is the constraint for the tag value I am looking for?
2. What does mnogo want from categories table? (There is no $(DY) param in the
templates.)
3. Why are the more queries (1 query per hit) to the same data what was retrieved
already?
4. Why does these more queries use crc32 as id instead of rec_id?
I use DBMode single, mysql, v3.2.3.
Reply: <http://www.mnogosearch.org/board/message.php?id=4357>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
