On Jun 21, Giuseppe Cowo Corbelli <[EMAIL PROTECTED]> wrote: > It has been tested with Postgresql 8 and Sqlite 3. The tables/indexes > are created successfully.
Very good! Anyway - you won't believe it! - MySQL (AKA "il buco col database intorno") has a problem: it categorically refuses to create an index over a TEXT (or BLOB) column. To tell the truth this is one of its very few behaviors that seems reasonable. I suppose that the only workaround is to set a limit to the length of the index, and hope this doesn't break postgres/sqlite/otherDB. :-/ > 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'] Yep; I have it already fixed in my 0.8dev-r1631 - I don't remember if I've fixed it manually and/or if I've opened a bug report. > 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. I think they are superfluous and can be removed. > 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) Ah-Ahhh! (if I'm allowed to quote Lara Croft ;-) Thank you for the explanation: now the difference with separated indexes makes a lot of sense. > This is what I recall after a lunch of roasted pork and Grana :-) Italians! ;-) -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
