Additional information.
MySQL Version: 5.0.33
Platform: Mac OS X 10.4.8
Machine Spec: 2.16GHZ Intel Core 2 Duo Memory 2GB MHZ SDRAM
Test was done using the following dummy data.
employees table:
20 ascii chars as employees' name
skills:
INSERT INTO skills
(name)
VALUES
('C'),
('C++'),
('C#'),
('Java'),
('Perl'),
('PHP'),
('Python'),
('Ruby'),
('WebDesign'),
('Javascript'),
('Database')
;
companies:
INSERT INTO companies
(name)
VALUES
('Microsoft'),
('Apple'),
('Google'),
('Yahoo'),
('eBay'),
('Amazon'),
('AOL')
;
employees2skills:
INSERT INTO employees2skills SELECT id, 1, 2, NOW() FROM employees;
# Yes, 1000000 have same skill_id, co_id, and even mod_time.
# selectivity is extreamly low
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
