Re: Distributed Fulltext?
Last week on Slashdot there was an article where the CEO of Google mentioned he uses DRAM (solid state disk arrays) rather than hard drives for the indexes and arrays because of the magnitude of difference in speed they provide. There's your 10^6 difference in speed (or part of it). G. Google Articles on Slashdot: http://slashdot.org/article.pl?sid=02/02/03/1339216mode=thread sql, MySQL, db, rdbms, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Distributed Fulltext?
Last week on Slashdot there was an article where the CEO of Google mentioned he uses DRAM (solid state disk arrays) rather than hard drives for the indexes and arrays because of the magnitude of difference in speed they provide. There's your 10^6 difference in speed (or part of it). G. Google Articles on Slashdot: http://slashdot.org/article.pl?sid=02/02/03/1339216mode=thread sql, MySQL, db, rdbms, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select woes
Hello. If anyone has a quick moment, I would appreciate some suggestions with regards to the following select statement: SELECT widget_src FROM widgets WHERE items.foo='abc123' and item_details.item_type='I' and items.item_detail_id=foo.item_detail_id; Upon execution, I'm getting ERROR 1109: Unknown table 'items' in where clause. However, widgets, items and item_details all exist, in the same database. In looking at the MySQL manual, section 6.4.1 (SELECT syntaxt), the following is written: You can refer to a column as col_name, tbl_name.col_name, or db_name.tbl_name.col_name. which I'm doing, and all tables referenced are in the same database. Here's the following output from mysql status: mysql status -- mysql Ver 11.15 Distrib 3.23.44, for -freebsd4.4 (i386) Connection id: 295 Current database: test_database Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.44 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 5 days 20 hours 55 min 10 sec Threads: 1 Questions: 13038 Slow queries: 0 Opens: 200 Flush tables: 1 Open tables: 7 Queries per second avg: 0.026 -- mysql If anyone has any suggestions or pointers to nudge me in the right direction, I'd be most appreciative. --George Ellenburg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php