Thread: simple JOIN with sub SELECT strangeness

A rude stop of MyISAM necessitates a CHECK and possibly a REPAIR. Suggest you do CHECK TABLE tokens; REPAIR TABLE tokens; -- if the CHECK was not 'ok' ANALYZE TABLE tokens; -- maybe its stats need refreshing

No names. Not even certain whether the SSNs are all valid. It doesn't matter, though. Let's just assume that it's a randomly generated anonymous SSN death index, which is probably closest to the truth at this point. The memory analysis for a random fetch definitely made that clear. It just seems that no matter whether the SSN is random that if the SSN is sequentially ordered as a 9-digit number such that 111223333 <...

Thank you very much Rick, that make sense. By the way in the gift table I have a little more than 10 million rows. Fitsum

Yes. it is - the quotes!. This column is defined intentionally as varchar but I'm operating on decimal strings so I missed this issue. Adding quotes makes the job. Thank you for your analyse and pointing the sollution. Thank you for note about autoincrement, Indeed there should be unique index, just for a case. Thank you and best regards.

HOLA A TODOS. El motivo de mi consulta es la siguiente dado qeu yo es una duda muy facil en bases de datos MYSQL. Resulta que me encuentro trabajando unas serie de consulticas en una base de datos con tabls de 500000registros, 400000 registros y necesito hacer una consulta que me las relacione pero el computador se me muere pensando . mire la consulta es la siguiente en MYSQL : SELECT fecha2, fechasolicitud, NumeroCuenta2, NombreOficina2,...

Aditional information: * Materialized view table is MyIsam engine * users table is InnoDB engine Any more information you need? Thanks!

CREATE TABLE `yp_companies` ( `company_id` int(11) NOT NULL default '0', `company_name_en` varchar(100) NOT NULL, `company_name_ar` varchar(100) character set utf8 NOT NULL, `address_en` varchar(200) NOT NULL, `address_ar` varchar(200) character set utf8 NOT NULL, `pobox_name_en` varchar(100) character set utf8 NOT NULL, `pobox_name_ar` varchar(100) character set utf8 NOT NULL, `office_en` varchar(255) character set utf8 NOT NULL,...

Hi Rick, i'm supposed to help writing a paper about mutual synergistig effects of queries. There are some DB Systems which support the parallel execution of a bundle of queries with features like recyling results, creating temporay views... I personally only used MySQL for practical purposes and never really had any performance problems(besides the ones in my code). For now i just have dicovered the...

tested on mysql 5.1.31-1ubuntu2 and mysql-5.1.36-solaris10-x86_64 (got from mysql.com) ========= CREATE TABLE table ( table_id INTEGER, length INTEGER, name VARCHAR(16) ); ALTER TABLE table ADD INDEX (table_id, length); INSERT INTO table3 VALUES (10, 100, "hundred"); INSERT INTO table3 VALUES (20, 200, "two hundred"); INSERT INTO table3 VALUES (30, 300, "three hundred"); INSERT INTO table3...

The "7 rows" is really what mysql scans. On the real database, with 200000+ rows, this request is really slower. At last, i rewrote my query to use the form: SELECT table3.name FROM table3 WHERE table2_id=10 AND length=100; in real life, something like: SELECT table3.name FROM table3 WHERE table2_id = (SELECT table2_id FROM table2 WHERE xxx) AND length = (SELECT length FROM table2 WHERE xxx) awful...