My new house used to have the same issue - damn hot and warm especially during the night. So I decided it would be best to open up my hall windows (no sliding door), kitchen window and downstairs room window every day after I wake up.

Ever since then, the ventilation had improved and the heat had reduced.

Not every windows, probably the first one or middle one would do for every portion (hall, kitchen, etc.).