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
vBulletin® v3.8.0, Copyright ©2000-2012, Jelsoft Enterprises Ltd.