Re: update performance

El Mi' 14 Feb 2001 19:48, escribiste: > In the year of Our Lord Tue, 13 Feb 2001 09:32:10 -0300, "Martin A. > Marques" > > > >Don't worry, my friend Obnoxios, with a par of programing (external) > > tricks fixed it. > > > >But if you want to know: > >Lets say I pass to a user a list of all the rows of the table (not all the > >info, but an id, name, and a bool field) and the user sends back an array > >with the ids (well, kind of, cause it's a bit more complicated) of the > > rows which should have the bool field activated. > >The question was: How can this be done in an effective way. > > > >Understood? > > No. Well, I can recommend you an analyst. :) > As they say in Austin Powers: "Throw me a frickin' bone here someone...?" Hey I thought that had another meaning.... ;-) > Language? Table structure? PHP. very simple table structure: CREATE TABLE booleano ( id SERIAL UNIQUE, nombre VARCHAR(100) NOT NULL CHECK (nombre <> ''), apellido VARCHAR(100) NOT NULL CHECK (apellido <> ''), cargo INT, activo SMALLINT, -- 1 activo, 0 inactivo FOREIGN KEY (cargo) REFERENCES table1 (id_cargo) ); I can't recall now (would have to check it out) if the search is on the cargo column or the id column, but it doesn't matter because both are indexed and of the same type. Saludos... ;-) -- System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------

In the year of Our Lord Thu, 15 Feb 2001 11:39:52 -0300, "Martin A. Marques" <martin@math.unl.edu.ar> spake, saying: > >El Mi' 14 Feb 2001 19:48, escribiste: >> In the year of Our Lord Tue, 13 Feb 2001 09:32:10 -0300, "Martin A. >> Marques" >> > >> >Don't worry, my friend Obnoxios, with a par of programing (external) >> > tricks fixed it. >> > >> >But if you want to know: >> >Lets say I pass to a user a list of all the rows of the table (not all the >> >info, but an id, name, and a bool field) and the user sends back an array >> >with the ids (well, kind of, cause it's a bit more complicated) of the >> > rows which should have the bool field activated. >> >The question was: How can this be done in an effective way. >> > >> >Understood? >> >> No. > >Well, I can recommend you an analyst. :) I tried that, but it didn't work.