What happens in the database when an ad expires?
Problem:What happens to the ad/auction in the database when it expires? Does it go away? Is it archived?
Solution:When an ad/auction expires it initially remains in the "live" database table geodesic_classifieds table for a default period of thirty days and is marked as not live. Once it has been thirty days (set at default and editable in the admin tool) and marked as not live the ad is then moved to the geodesic_classifieds_expired database table and is stripped of any images, category id, extra questions,...etc. This leaves it with only the core data...i.e. ad id, ad title, ad description, etc... The amount of space required to store this information is extremely small and is therefore stored indefinitely as an archive. These ads can be removed by if you feel that this table is becoming large. Please note that the information that is stored in this table is extremely small and will not hender the performance of the database.
For more on why the listing isn't immediately archived, how and where to adjust the date of archiving from expiration and even having archived listings removed from the database by the software look to these support wiki articles