Re: At Performance Limit for 2 GB RAM?

[KimSeong Loh]

Try the following and see if there is any difference.

For table y_statsinfo, what is the order of the primary key
(stn_id, metadata_id) or (metadata_id,stn_id) ?
I hope it is (stn_id, metadata_id).

For table y_metadatatemp, you should index the column (metadata_id)

With the above I would expect the optimizer to read table y_statsinfo first using the primary key to find records with stn_id = 1250 then find the matching row in table y_metadatatemp.

But, not sure if it will be better or not.