fenway

Or remove the duplicates? I suggest you check the link in my sig and see how best to provide the forum members with info about your problem.

Just like I have concerns with "NOT IN"... ;-)

That's not what I intended.... find out how many less-than-16 dates are available, and insert one record into each of that dates N times.

I disagree... the UNION will return the rows in the "order" the select statements are provided; and you can sort each one of the select statements by "name".

Did you even consider my suggestion?

This thread far too long for me to catch up... where do things stand now?

Try UNION DISTINCT (but then you'll have to drop "match type")

Say what? Why are you doing it that way? Use mysql_fetch_assoc() to iterate through the results -- don't issue *another* query for no reason.

Sounds like a count() and a left join... is null.

That's sounds like an accident.. I wouldn't rely on that.

I have no idea what you're talking about.

Careful now... you're on VERY thin ice.

Maybe with mysqli(). Anyway, 600K string concats aren't fast, either.

Why not just count how many are on each day, and assign N orders chronologically?

Multple statements aren't supported by mysql_query(), AFAIK... see my comment above.

If you're confident it's not the "tables" or database, then this is wrong board.

If you're really emptying the table all the time, then use TRUNCATE. Also, use multi-valued insert statements for bulk operations. Even better, use joins to generate the dummy data. MyISAM will leave "holes" during delete operations -- so because your subsequent select statement requires a full table scan, it takes time to page through the records, even though they're "deleted" -- they still exist on disk.

You didn't answer my question.

Yes, it will return in numeric context -- but DATE() won't!

Yes, you can create a summary table.

If this isn't resolved soon, I'll move it to the appropriate forum.

Help with what?

Hold on a sec... you have to specify INTERVAL when "subtracting" dates like that!!!! WHERE DATE(timestampField) = CURDATE() - INTERVAL 1 DAY

And UTF-8 isn't general enough?

I doubt that this can be reproduced reliably... innodb or myisam/