Posted by Scott Reynolds on July 31, 2006 at 6:49pm
Ok major speed fixes. Redid the query compeletly and added a average user vote table. This allows for the movelens database to run MUCH MUCH MUCH MUCH FASTER. I will begin testing it later this week and give back some scores that should be interesting. Try running the update script for me. I did not test it out and I am worried that I didn't write it properly (my first update() :-D ).
Still working on creating a query object that will prevent the one issue that is in the queue right now. More to come soon...
Scott
Comments
ACK! testcases are wrong
Ok, I somehow managed to misform all testcases. I made a mistake somewhere and all testcases are already part of the databases. Therefore, the engine will never recommend the test cases...
Sorry huge mistake.
cre.install
cre.install is missing 'function' on line 50.
running the upgrade script produced lots of SQL errors:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'content_ids(content_id1,content_id2)' at line 1 query: ALTER TABLE cre_similarity_matrix INDEX content_ids(content_id1,content_id2); in includes/database.mysql.inc on line 120.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'content_type(content_type1,content_type2)' at line 1 query: ALTER TABLE cre_similarity_matrix INDEX content_type(content_type1,content_type2); in includes/database.mysql.inc on line 120.
user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE cre_similarity_matrix ADD COLUMN similarity_id int(10) NOT NULL auto_increment; in includes/database.mysql.inc on line 120.
warning: array_merge() [function.array-merge]: Argument #2 is not an array in update.php on line 307.
warning: Invalid argument supplied for foreach() in update.php on line 517.