;--8<--8<--8<
and it reports ERROR 1111 (HY000): Invalid use of group function
Could anyone tell me how to use ON DUPLICATE KEY UPDATE with GROUP BY
functions ?
Sincerely,
Aleksandr Guidrevitch
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Since you are already splitting your data into "fulltext columns" and
"other data" I would keep that design. Others on the list have greatly
improved their performance by running their tables in this same
fashion. If by some chance your "non-fulltext" columns are all fix
Hi there,
Is there any common strategy (of using indexes)
to avoid filesorts while sorting searches by a field ?
Eg. I want fulltext search, then sort results by
some other table field.
For example .:
create table article (
id int not null primary key auto_increment,
sort1 int not null,
Hi Chetan,
Well, I would suggest to add separate index on
either on bsc_id or data_GenTime,
whichever returns smaller result.
Then check with explain that this index is used
May
chetan t wrote:
Hi mike,
as i have mentioned in my previous mail
the table structure which i am using is as fallows,
CR
KE '%block%'; For me
there is 1536 (?!)
5. "SET GLOBAL key_cache_block_size = 2048";
6. go "REPAIR TABLE end_time" (the table with fulltext search you are
querying)
7. here we are, all the MATCH() with ORDER BY queries take 0.01, only
some of them are 0.02 secs,
not more
Hi All, this was already posted on mysql forum "preformance",
but forums are really slow, so sorry for the crosspost :)
My objective is to implement quick, really quick complex fulltext search
with 'order by' (< 2 seconds).
The actual table I'd like to search is `lot`. I've created 2 helper
table