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
MATCH (cds.title) AGAINST ('+music +mix +2001' IN BOOLEAN MODE)
and artists.artistid = cds.artistid AND artists.artistid =
tracks.artistid AND cds.cdid = tracks.cdid
-Original Message-
From: Chuck Gadd [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 21:50
To:
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
The boxes running the MySQL were isolated from other users so there was no
activity on them while I was performing the benchmark tests.
There was no tuning - I just installed the MySQL from their binary
packages, that is I was using the default config files (hoping that they are
the same - I w
Nesh,
> With all of the benchmark test I have used the same DB structure, same
> TABLE structure, and finally same iterations.
>
> This probably means that Solaris I/O is really poor, or there is some other
> explanation (like changing some kernel parameters to get Solaris working
> well with
: Sherzod Ruzmetov aka sherzodR [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 5 February 2002 11:14 AM
To: Nesh Nenad Mijailovic
Cc: '[EMAIL PROTECTED]'
Subject: Re: Speed difference
: after timing the program that was targeting MySQL on different
platforms
: the results are (clie
: after timing the program that was targeting MySQL on different platforms
: the results are (client program running always from the same box that is not
: hosting MySQL):
:
: Windows NT - 25 sec (Intel P-III)
: Linux - 27 sec (Intel P-III)
: Solaris 2.7 - 1 min 40 sec (Ul
13 matches
Mail list logo
