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

Reply via email to