Hi Everyone,
I need to select the last record in a very large database via scripting.
Currently I use the following, but when over 2 million records it can be a bit slow as it's doing more processing than needed maybe.
Code:
//THIS SETS THE LAST ENTRY IN THE DB TO THE CURRENT STUDENT
var Rset = KYW_db_usr.ExecuteSQL("SELECT UserName, UserID FROM Users_Records");
Rset.LastRecord();
CurrentStudentName = Rset.UserName;
CurrentStudentID = Rset.UserID;
Any suggestions for best options, UserID is an auto incrementing number. I was trying to use "SELECT * FROM Users_Records ORDER BY UserID DESC LIMIT 1" SQL but the LIMIT 1 keeps throwing an error.
Login
FAQ
Search
