fenway

Minus the colons, sure -- are there no other tables?

What's "it"?

I don't what what vertigo is -- nor does it matter. Icons don't mean anything. Tools don't mean anything. Go to the command line, and try to connect to the server. Start the service, and see if it's started. There's nothing simpler than that.

You're not listening to anyone offering help. Both servers cannot be working fine if they're running on the same port.

You need to verify that you actually know how your mysql server is configured, and that those settings match on both sides.

Go back after how long? When do you want it to be random again? How did you decide it should be random the first time?

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

And have you posted that EXPLAIN for us to review?

Since you haven't shown us anything, it's impossible to say.

Or, use SQL_NO_CACHE.

Well, there are other full-text searching options. And MEMORY tables aren't terrible, provided there aren't many.

Well, you can't use "USING" in place of joins.

LEFT JOIN without "IS NULL" isn't equivalent to "NOT IN".

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

Well, the temporary table is still on disk. Granted, you'll save the random disk I/O on the larger table.

Good luck -- you'll seriously need it.

Yes, the number of rows increases -- the count isn't stored anywhere. I don't understand your table layout, though.

I assumed that's what you started with, and were looking for a better solution -- juddster's advice was appropriate.

You're confused -- there is no such limitation.

Spreadsheets are bad because they're not meant for storing relationships.

What?

Sorry, what dosen't work?

No, it's not -- "local host" is not the same as "localhost".

Each one of those "entities" needs to be a separate table.

That shouldn't take a full second.