Re: mysql subquery too slow

[S C]

Thanks for your reply Felix

ALSO, s2 trade date should be the last date that the trade appeared

For example stack table looks like this:

112323 BOOKED 100 2005-10-28 NEW
112323 BOOKED 200 2005-10-29 MODIFIED
112323 BOOKED 200 2005-10-29 PROCESSED --- This is where loan got processed
999999 BOOKED 100 2005-10-31 NEW
112323 BOOKED 200 2005-11-01 PROCESSED ---- This is an erroneous entry

So when I lookup 112323 on 11/01 I must compare with 10/29 ONLY Then look at the status of PROCESSED.

I have to lookback to find the last date of occurance of trade 112323 in addition to what you have suggested.

Shantanu