nigel wood wrote:
Here's a rough table stucture. The indexes in events tables would be TargetId. But problably TargetId+EventDate probably eventId+event date as you found more uses/added paging.
Well that didn't format very well :-( The tables structures are: User/Actor ======= TargetId Username EventType ====== EventTypeId LogMesssageText (optional) CurrentEvents,ArchivedEventsNN,MergedEvents ============================= EventId TargetId EventTypeId EventData EventDate HTH Nigel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
