CHEMICAL BLOGSPACE HEADLINES

Saturday, August 30, 2008

More SQL trouble..

I'm not happy to report this, but we got another bit of SQL trouble... we had this a few weeks back too, but it solved itself then... not sure about now :(



I hope to get this solved shortly...

3 comments:

Egon Willighagen said...

And, we're good again...

Anonymous said...

Egon, this one's easy to miss and causes real problems:

Have you put indexes on all of your primary keys?

Egon Willighagen said...

Rich, I'd have to check the original source code... I basically just installed the Postgenomic.com software, and extended it a bit, but not really dived into the MySQL specifics...

Here's the source:

http://code.google.com/p/openreview/source/browse/trunk/conf/pg_posts.schema