View Single Post
Old December 25th, 2008, 08:46 PM   #9 (permalink)
dfidler
Junior Member
Verified Customer
 
Join Date: May 2008
Location: London, UK
Posts: 8
Hey Chuck,

I'd classify this (Kirby's original bug report) as a performance bug; especially for sites that make heavy use of the favorites functionality.

ppgal_favorites.userid is joined/filtered upon in misc.php and showimage.php.

Note: I'm using vbG v2.4.3.

In the meantime, I've done the following for my site:

mysql> alter table vb_ppgal_favorites add foreign key (userid) references vb_user (userid) on delete cascade;

Cheers,
Dave.
dfidler is offline   Reply With Quote