fenway

I don't follow -- just upgrade the DB after following mysql's instructions.

300K rows is nowhere near giant -- don't even worry about partitioning at this level.

Transactions are not per session -- ACID compliance ensures that this is not the case.

Easy -- you don't have an index on (field1,field2).

FIND_IN_SET() does this too, if it's comma-separated.

Well, check mysql_errror() -- and remove the @ sign before mysql_query(), since that silences errors. What does that echo return?

Everything's possible -- but this is really two issues: one -- grab all of the values from all of the tables, and two -- deal with php to populate and write out html accordingly.

It's not -- where did you get that idea?

Let's start again -- you want the most recent for each forum, correct?

No, no no no no. You need the full comparison for each field.

By forum.

This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=306977.0

Just chain them together with OR... what have you tried that didn't work?

Sorry, I thought it said correlated, not dependent -- though I do prefer the LEFT JOIN over NOT IN(). But no, not to the original query, just to the one you recently posted. Add an index on ( scriptID, siteID ) and see how it performs -- drop the other one, of course.

Again, drop the group by for a minute -- and dependent subquery is the problem. Use a LEFT JOIN ... is NULL instead.

The only reasonable "limit" being multi-valued insert statements.

Probably -- use a column alias.

Good point ... missed that... then SQL.

Please post EXPLAIN output again.

So solved? If so, please mark as such.

That's all but impossible -- executive this query from the command-line, or phpmyadmin, and prove it.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=306815.0

Not nearly enough information to help you out.

SQL is useful if you want to repopulate the table. Otherwise, CSV is deal. Everything else is just silly.

That's what the refman is for -- bh was even kind enough to link it for you.