Porl123 Posted July 7, 2010 Share Posted July 7, 2010 I'm not really sure of how much of a daft question this is but would it be more taxing on memory to do 1 or 2: 1. create a SELECT query to get all records that have timed out, then use a while loop to go through and delete them from the database or 2. just have a delete query which deletes all records where timer - time() < 1. there would on rarely be any rows affected by this query which would make me think that it's the more efficient option. i'm sorry if i've explained this terribly but i just needed some clarity. thanks to anyone who can help Link to comment https://forums.phpfreaks.com/topic/206945-memory-usage/ Share on other sites More sharing options...
fenway Posted July 8, 2010 Share Posted July 8, 2010 I'm guess 2 would be preferable. Link to comment https://forums.phpfreaks.com/topic/206945-memory-usage/#findComment-1083062 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.