Re: why the sql so slowly?

2010-06-17 Thread Ananda Kumar
How many records are there in this table. What is the select statement ur running. regards anandkl On Thu, Jun 17, 2010 at 10:05 AM, hewei heweiwe...@gmail.com wrote: now , I need to select a table per minute. 1. the table struture:

Re: why the sql so slowly?

2010-06-17 Thread hewei
1.How many records are there in this table. ==6000 rows. 2.What is the select statement ur running. == --- I need to select the table 'table_code' per minute,and the sql is like : select code from table_code; ---

Re: why the sql so slowly?

2010-06-17 Thread Ananda Kumar
you want to select all rows from the table On Thu, Jun 17, 2010 at 2:05 PM, hewei heweiwe...@gmail.com wrote: 1.How many records are there in this table. ==6000 rows. 2.What is the select statement ur running. == --- I need to select the table 'table_code' per

Re: why the sql so slowly?

2010-06-17 Thread hewei
you want to select all rows from the table? === YES

MySQL Community Server 5.1.48 has been released

2010-06-17 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see

Re: opening a server to generalized queries but not too far

2010-06-17 Thread Raj Shekhar
In infinite wisdom don-mysq...@isis.cs3-inc.com (Don Cohen) wrote: The question is what I have to prohibit in order to prevent either updates or access to other tables, or perhaps other things that I should be worried about but haven't yet thought of. One option here might be to use mysql