| So this is the same idea as with mail, except mail only needs to keep track of one number (the id of the last message). This would keep track of the latest timestamp of each opened trade message, and the PHP would SELECT * FROM the trade table WHERE the indexed last adjustment is more recent than this number, which would happen for each trade you're viewing. |
