PDA

View Full Version : PLD_RSS_FEED_SEQ


guaranis
12-12-2005, 01:45 PM
What is the use of this table?
The field ID is already in auto_increment.
When you insert a new feed, the id is already going to be auto-incremented without the need of this extra table.
Is there another use?

David
12-12-2005, 02:15 PM
We use this also phpLD for tables and links. I believe it is a faster way to get the total count. There may be some other reasons for its use also.

guaranis
12-12-2005, 03:06 PM
Ok, this could be done on the table PLD_RSS_FEED directly by the
SHOW TABLE STATUS

You can find the information about the number of rows.
This will avoid 4 extra tables.

David
12-12-2005, 03:43 PM
I know there was a pretty good reason, but it escapes me right now.
I'll try to find out.

yktan
12-14-2005, 04:46 AM
Hi guaranis, all _SEQ tables are also used for cross-database sequencing control (used for auto-increment primary key). Some databases do not have sequencing control built in, so this is needed.

Regards,
York Kie