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 Quote Link to comment Share on other sites More sharing options...
fenway Posted July 8, 2010 Share Posted July 8, 2010 I'm guess 2 would be preferable. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.