Ok, I've just committed some changes in the index system.
It has been tested with Postgresql 8 and Sqlite 3. The tables/indexes are
created successfully.
1) There's a bug in sqlobject 0.7.0 that prevents creation of indexes.
index.py:137 in _get_name
of course it is self.kw['name'] instead of kw['name']
2) A question: are indexes on
AkaNames:name, AkaNames:imdbIndex,
AkaTitle:title, AkaTitle:imdbIndex, AkaTitle:kind, AkaTitle:productionYear
needed? I've disabled them, so if they are needed let me know and I'll enable
them.
3) For Davide: to make it short and simple, an INDEX ON (ColA, ColB) makes
sense when a typical query looks like "ColA = x AND ColB = y".
That is, when you test a part of the columns involved in the index:
*) In the same order which they appear in the index definition (ColB AND
ColA does not work)
*) With an AND condition.
This is what I recall after a lunch of roasted pork and Grana :-)
--
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
