-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Oops, this is where the Oracle experience is a hindrance :/
Thanks! On 07/14/2010 01:15 PM, Benoit Thiell wrote: > Hi Victor, > > KEY is what is used to create the indexes. > > Excerpt for the MySQL documentation: > "KEY is normally a synonym for INDEX. The key attribute PRIMARY KEY > can also be specified as just KEY when given in a column definition. > This was implemented for compatibility with other database systems." > > Benoit. > > On Wed, Jul 14, 2010 at 7:12 AM, Victor Engmark <[email protected]> > wrote: >> > I couldn't find any in my current branch except the one I created for my > own table, and after `git checkout master` and `git pull` I get the > following: > > $ grep -i '\sindex.*(' ~/src/invenio/modules/miscutil/sql/tabcreate.sql > INDEX (reply_order_cached_data(40)) > INDEX (reply_order_cached_data(40)) > > Where can I find a revision with more indexes? > > PS: I don't mean primary key indexes, which AFAIK are created > automatically, but rather indexes for columns which are queried often > for equality (for example `id_user = %d`). > > Cheers, > > On 07/14/2010 11:40 AM, Benoit Thiell wrote: >>>> Hi Victor, >>>> >>>> indexes are created for lots of Invenio tables. Please refer >>>> to modules/miscutil/sql/tabcreate.sql. >>>> >>>> Benoit. >>>> >>>> On Wed, Jul 14, 2010 at 4:54 AM, Roman Chyla <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> Correct me someone if I am wrong, but not using foreign keys is not >>>>> that uncommon in many CMSs (though special indices are often created, >>>>> not only those for PRIMARY and UNIQUE keys as in Invenio). I don't >>>>> believe constraints are maintained by Python (how could they be, >>>>> unless one uses some object relational mapper like sqlalchemy?) and >>>>> that is another reason for dealing with constraints manually, ie. >>>>> writing the query by hand, also for other CMSs. It is forcing some >>>>> different approach to executing queries, especially, if they should be >>>>> portable amongst many RDMS. >>>>> >>>>> roman >>>>> >>>>> On Wed, Jul 14, 2010 at 10:27 AM, Victor Engmark <[email protected]> >>>>> wrote: >>>> Hi all, >>>> >>>> Is anyone using native MySQL foreign keys / unique constraints / indexes >>>> at all in Invenio? For example, the only place I could find creation of >>>> an index is in modules/bibrank/lib/bibrank_citation_indexer.py, and >>>> that's just for a temporary table. Are constraints maintained in Python? >>>> Has anyone benchmarked those compared to MySQL constraints? And how do >>>> you survive performance-wise without indexes? >>>> >>>>>> >>>>> > - -- Victor Engmark <http://l0b0.wordpress.com/> “Professionals treat all warnings as errors. Amateurs ignore warnings. Idiots suppress warnings.” JD on The Daily WTF <http://thedailywtf.com/Comments/Extensive-Date-Parsing.aspx#224958> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJMPZynAAoJEMj+WTFE4nA6RdAH/R1CH8/7NQb5sMNpq5z5xSWg ip0mkDWRCGO/d1XyuR+oy4DzhIeixLZo4XW3fmpS7P8O1GV6IAjsPNd3K6ZHloe3 xEQaLbJS0WboLpHnHS/Aoaj0e2PCQOKG8mHC79Moahf8PO+5geB+zGdydCmXOmYw wz4q173k7iuklh74rK6QqK5rb4IC0MEqQxMCLm2SQo9VGcFa4L7lIuaBj24SzY9D XUzn+J59brv8d8/NCyVc6mWGVkqBuycdEo+5Ai39Xf/qd6fSR0VAHzO80OZujzcu RESQcNHZgoVvzPqmpyQ6F6BIIePWOqftyyrogxxaJ06PflvZFy6zGTl5QNrtLuY= =eT6+ -----END PGP SIGNATURE-----
<<attachment: victor_engmark.vcf>>
