PDA

View Full Version : vb_picturecomment_hash table: entry really needed for every comment?


jerx
09-25-2008, 10:00 AM
I am trying to import pictures from a different user gallery into vb' s user gallery. Therefore I need to generate some data.

I think the picturecomment_hash table stores hash values for every comment to prevent double posting or spam. Therefore I would need to generate an entry for all my comments.

Although this would not be difficult, I was wondering if this is really needed. All my comments have been posted way before the last five minutes. In my opinion it would just waste hard disk space. Would it harm to not generate rows for each of my comments in this table?

It looks like the table will not be cleaned at all. I think it would improve performance and save disk space, if you remove all entries (created more than 5 minutes ago) from time to time. Can anyone please explain why this has not been taken care of? Or has it just been forgotten?

Edit: I just noticed that postings have a hash table, too. Impex does not generate hash entries, so I assume it is save to not generate entries for picture comments as well.

Marco van Herwaarden
09-25-2008, 11:16 AM
I would suggest to use the DataManagers to add these images. The DM will automatically take of things as adding hashes.