Hi!
Sorry for delayed answer - I was on vacations...
On Dec 08, Uros Kotnik wrote:
> OK, I will give you more details.
>
> Table CDS, have 1,053,794 rows, FT index on title,
> Data 67,646 KB, Index 70,401 KB
>
> Table ARTISTS, Rows 292,330, FT on name,
> Data 8,096 KB
> Index 17,218 KB
>
> T
x' ) AND
MATCH ( cds.title ) AGAINST ( '2001' )
Regards
-Original Message-
From: Chuck Gadd [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 21:50
To: Uros Kotnik; [EMAIL PROTECTED]
Subject: Re: Speed difference between boolean full-text searches and
full-text
Uros Kotnik; [EMAIL PROTECTED]
Subject: Re: Speed difference between boolean full-text searches and
full-text searches
Uros Kotnik wrote:
> It makes sense, but Sergei G. said :
> "And are you sure the numbers are correct, the first query - the one
> without "IN BOOLEAN MODE"
Uros Kotnik wrote:
It makes sense, but Sergei G. said :
"And are you sure the numbers are correct, the first query - the one
without "IN BOOLEAN MODE" - is faster ? I would expect the opposite."
I guess that for my DB I can't expect satisfied "in boolena mode" times
?
But also when searching wit
ld be satisfied with 0.5 - 1 sec. times
-Original Message-
From: Chuck Gadd [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 13:17
To: Uros Kotnik; [EMAIL PROTECTED]
Subject: Re: Speed difference between boolean full-text searches and
full-text searches
Uros Kotnik wrote:
Uros Kotnik wrote:
Time for first SQL : 21 sec.
SELECT artists.name, cds.title, tracks.title FROM artists, cds, tracks
WHERE artists.artistid = cds.artistid AND artists.artistid =
tracks.artistid AND cds.cdid = tracks.cdid AND MATCH (artists.name)
AGAINST ('madonna'IN BOOLEAN MODE) AND
MATCH (cds
ds, tracks I get time of 1.9 sec. instead < 1
sec. ?
Regards
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 00:02
To: Uros Kotnik
Cc: [EMAIL PROTECTED]
Subject: Re: Speed difference between boolean full-text searches and
full-text
cds, tracks I get time of 1.9 sec. instead < 1
sec. ?
Regards
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 00:02
To: Uros Kotnik
Cc: [EMAIL PROTECTED]
Subject: Re: Speed difference between boolean full-text searches and
full-text
Hi!
On Nov 27, Uros Kotnik wrote:
> Executing this SQL, takes ~5 sec.
>
> select artists.name, cds.title, tracks.title from artists, tracks, cds
> where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
> and MATCH (artists.name) AGAINST ('madonna')
> and MATCH (cds.title) AGAINST
Executing this SQL, takes ~5 sec.
select artists.name , cds.title , tracks.title from artists, tracks,
cds
where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
and MATCH (artists.name) AGAINST ('madonna')
and MATCH (cds.title) AGAINST ('music')
and MATCH (cds.title) AGAINST ('
10 matches
Mail list logo
