G2_Entity Table size

markusr

Joined: 2008-05-18
Posts: 5
Posted: Fri, 2010-01-08 09:07

Hi there,

i just figured out that my table g2_entity has over 140.000 entries with a size of 20,1MB.
Also the table g2_ChildEntity has also aroung 140.000 entries with a total size of 7 MB.

Why is that so big with only 2422 pictures inside. How can they be cleaned and come with the size down. Or is this normal??

Thanks alot.
Mark
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2010-01-08 14:10

The g2_entity table contains an entry for every gallery item and I mean every item - every user, movie, the movie's thumb, each image, image's thumb, each image resize, album items, album thumbs...........
FYI 20.1MiB is nothing(that's megabits not bytes).

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
markusr

Joined: 2008-05-18
Posts: 5
Posted: Fri, 2010-01-08 15:09

Hi,

i think these are MegaByte (see the screenshot)

and over 140.000 entries..... sounds strange.

regards,
Mark