I try to use the activity stream for the users to post the location, just like posting an update . The location is then saved in the database. Now here comes the problem. I am not sure where should I put the latitude and longitude information, in the “wp_bp_activity_meta” table or “wp_post_meta” table?
When reading the codes in Buddypress Skeleton Components, the author suggests adding custom data as post meta. But what’s the difference between ‘activity_meta” table and “post_meta”? I don’t know if it will be a problem when the data gets so big. Also I am not sure which way is better for data retrieving and handling outside the activity streams. I would really appreciate if someone can enlighten me to the pros and cons of each.
Thanks a lot.