Davide Alberani wrote: >> Anyway, regarding your message: that's a very good news! :-) > > Talking about the implementation: I think I can easily modify > the dbschema.py module to include a function to create the > indexes; I'll do this in the next days. > > Now my doubts are about what indexes to create: Giuseppe (ehi, any > other volunteer with a bit of experience in database design is also > welcome :-) can you take a look at the currently defined indexes? > > Critical tables are CastInfo, Name and Title. > I'm not sure that the current indexes are the best ones.
Let's start with these 3. What are the most common select operations on these tables? -- Giuseppe "Cowo" Corbelli ~\/~ My software: http://cowo.yoda2000.net -<! Non c'e' niente da dire in proposito. Tutto quello che uno deve fare e' colpire i tasti giusti al momento giusto, e lo strumento suona da solo. !>- J.S. Bach _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel