mos wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 was just
created with 2 columns and is empty.
The select distinct col1 from bigtable takes only 2 minutes to run
in the database?
Thanks in advance.
--
Angelo Zanetti
Systems developer
*Telephone:* +27 (021) 469 1052
*Mobile:* +27 (0) 72 441 3355
*Fax
Dan Nelson wrote:
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables in order to
speed up the data
Thanks guys it worked!!! I really appreciate your help.
this is the one that worked:
SELECT u.UserID
FROM Users u
LEFT JOIN BuddyList bl
ON u.userID = bl.buddyID AND bl.userID = '$userid'
WHERE u.isactive =1
AND bl.userID is null
and u.UserID != '$userid';
Hi guys.
I'm having a problem deciding whether a left join is suitable for what i
want to do.
I have two tables
A Users
-userID
-isactive
B BuddyList
-userID
-buddyID
what i want to do is to get all the users from A that don't exist as a
buddyID for a user (buddyList) also the user must be
ON u.userID = bl.userID
WHERE u.isactive =1 AND u.userid!='$userid' AND bl.userID is null
but this still returns some results that exist in the buddyList table.
[EMAIL PROTECTED] wrote:
Angelo Zanetti [EMAIL PROTECTED] wrote on 06/08/2005 12:06:51 PM:
Hi guys.
I'm having a problem deciding
is not
listed as a buddy for mike but bob is.
The query is half working but doesnt seem to be working for an
individual user.
thanks to those who have helped so far...
Michael Stassen wrote:
Angelo Zanetti wrote:
thanks shawn it seems to be working but i forgot to add that i need
--
Angelo Zanetti
Z Logic
www.zlogic.co.za
[c] +27 72 441 3355
[t] +27 21 469 1052
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
try
REPAIR TABLE 'tablename'
Gleb Paharenko wrote:
Hello.
REPAIR TABLE ... USE_FRM helps in difficult cases. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Per Jessen [EMAIL PROTECTED] wrote:
All,
I've got a table with about 25mill rows that was