hello,

from one part I have
MySql 5.1
from one other part
SQLite

the request is:
/************************************************** *************************
********************/
select word2url.idUrl as rIdUrl,
count(word2url.idWord) as rIdWordCount,
sum(word2url.score) as rScore
from keywords join word2url on keywords.id = word2url.idWord
join url2subject on word2url.idUrl = url2subject.idUrl
where url2subject.idSubj in (select id
from subjects
where (id != 1) and
( ('' = 1) or
( (idProp = '') and ((fMod &
16384) != 0) ) or
( (idGroup in (select idG from
groups where idU = '')) and ((fMod & 1024) != 0) ) or
( ('' != '') and ((fMod & 64) !=
0) ) or
( (fMod & 4) != 0) ))
group by rIdUrl
order by rScore desc
/************************************************** *************************
********************/

the facts are:
MySQL: 0.8s
SQLite: 37s

the question is: Why ? Any idea ?

PS: - the indexes and contents are the same in the two bases.
- the where clause is used to manage read rights on a Proprietor,
Group, Connected, World model

thank you

thierry

Thierry wrote:
Isn't this the point where one would start running EXPLAIN?

Both systems supports this command.

Regards,

Michael.
--
Which is more dangerous? TV guided missiles or TV guided families?
I am less likely to answer usenet postings by anonymous authors.
Visit my home page at http://michael.zedeler.dk/

Thank you

Explain is in effect supported by both system.
But Mysql gives I don't know what...
SQLite gives opCodes that I will try to profile by hand

thank you again.
If you a have any other idea I take it.

"Michael Zedeler" <michael (AT) zedeler (DOT) dk> a écrit dans le message de
news:hQzrg.73$nx4.58 (AT) news (DOT) get2net.dk...