Re: [PHP-DB] MySQL circular buffer

2008-06-21 Thread OKi98
> (i.e. stack_id > 500 && stack_id < 601 vs where stack_id = 500 limit 100) stack_id between 501 and 600 (stack_id > 500 && stack_id < 601) is much better What I would like to know is if anybody has experience implementing this sort of data structure in MySQL (linked list?) or any advice.

[PHP-DB] MySQL circular buffer

2008-06-20 Thread Andrew Martin
Hello, I'm looking at implementing a database-level stack for a (multi stack) mail merge queue (able to queue up to 1 million messages per stack). Current workflow: server 1 (containing main db) transmits data sets (used to populate mail merge template) to server 2 server 2 web-facing script (scr