table: CREATE TABLE price ( TIMESTAMP Timestamp NULL, id numeric(5,0) NOT NULL, price numeric(10,3) NULL, primary key (id) ); sql: update price set price=* where id=*;
On Feb 20, 2008 11:56 AM, Webb Sprague <[EMAIL PROTECTED]> wrote: > Post the table, the query, and the explain output, and then we can help > you. > > On Feb 19, 2008 7:38 PM, hewei <[EMAIL PROTECTED]> wrote: > > Hi,Every body; > > I have a table contains 100,000 rows, and has a primary key(int). > > Now ,I need to execute sql command like "update .......... where > id=*"(id > > is primary key). > > I expect execute 1200-1600 sqlcommands per second(1200-1600/s). > > In test,when the id increase by degrees in sqlcommands, then I can > reach > > the speed(1600/s); > > But in fact , the id in sqlcommands is out of rule, then the speed > is > > very slow, just 100/s. > > what can i do? can you help me ? > > >
