Data Space not freed up after deletion of records

hi, i’m facing this problem of having too large database size (1500MB), and the query is unable to return the results. i have tried deleting many records, but it doesn’t reflect in the database space; it remains the same at 1500MB!
how can i free up the space? or is there any other problems causing the query to fail? (*the query runs fine previously)