Post icon is taking up a lot of space in the database

This topic contains 2 replies, has 2 voices, and was last updated by headway 9 years, 2 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
March 5, 2015 at 9:36 pm #33060

headway
Free User

Post count: 49

I am going through and looking for ways to speed up the database, and noticed that the post icon is taking up the most space, which seems a bit odd. I have around 375,000 listings right now and here is what the table in question looks like (it is the largest table I have):

wp_geodir_post_icon – Entries: 1,075,727 , Data Size: 195.6 MB , Index size: 10.6 MB

I only have small icons uploaded to just some of the categories. I figured that each icon would only exist once and then would be called each time it is needed, rather than duplicated for each instance, but perhaps I am wrong.

Is there any way to optimize my database so as to increase its functionality?

March 5, 2015 at 10:36 pm #33083

Paolo
Site Admin

Post count: 31206

Hi,

in that table there are all info needed to retrieve maps markers without querying through the main post tables.

For each listing you have a row with 4 columns each:

id : 94
post_id 145
cat_id 43
json {“id”:”145″,”lat_pos”: “41.899305”,”long_pos”: “-87.62506″,”marker_id”:”145_43″,”icon”:”http://wpgeo.directory/wp-content/uploads/2014/05/hotel.png”,”group”:”catgroup43″}

This way we don’t have to join table and the queries are 10x faster.

Thanks

March 5, 2015 at 11:05 pm #33087

headway
Free User

Post count: 49

Ah, okay. I thought it was for the map marker images themselves.
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket