Re: How to make update rapidly?

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 <webb(dot)sprague(at)gmail(dot)com> wrote:

> Post the table, the query, and the explain output, and then we can help
> you.
>
> On Feb 19, 2008 7:38 PM, hewei <heweiweihe(at)gmail(dot)com> 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 ?
> >
>