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. tables:

Re: [PHP-DB] One field or a new table?

2008-06-21 Thread Evert Lammerts
mysql.com says: Foreign key enforcement offers several benefits to database developers: * Assuming proper design of the relationships, foreign key constraints make it more difficult for a programmer to introduce an inconsistency into the database. * Centralized checking of