On Apr 20, Jesper Nøhr <[EMAIL PROTECTED]> wrote: > I am using the sql data access system, but I'm confused how to > tell it only to fetch the runtimes in .update(). Does runtimes fall > under another keyword, or...?
Using 'sql', every information available about a movie/person is fetched with just one query (well... sort of, but it doesn't matter), because the cost to access a single info would not be much lower that the cost to fetch the whole data about a movie/person. If you have serious performance issues, you can try accessing directly the SQL database; the 'runtime' information (as you can see in the "info_type" table) has id = 1. So you can now query the "movie_info" table for rows with the movie_id field set to the movieID you're searching and info_type_id set to 1; the results will be a list of fields, with the 'runtime' data in the "info" column. HTH, -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
