Database - strange error

Question

I update a Access database by inserting new records which I want sorted by date. They get added at the end so I have do go in and sort them descending to move them up top. I save the database, close it, and reopen it days later. I use my DataReader FindLastDate() function at it shows the same new dates still at the bottom! Why is this? Is there a way to sort a database automatically or permanently? Is there a way I can insert my records at the top?

Answer 1

If not using server on session, then you can use cookies on client side

but I fail to understand why you don't want to use session? it helps in managing user requests in betterway. what you want to achieve by not using session? 

Answer 2

if you have memory issues, then instead of storing session in-proc (in memory),you can store the session in database server. this way ur memory will not be occupied by session

if at all you dont want to use session, then you can maintain user data using cookies or using query string

Answer 3

1000 concerent users is nothing, even the sites with millions of concerent users implement sessions

it depends on what resources you have

are you going to host by your own? or on cloud?

 

it will be better if you provide all the info. together while posting question, instead of writing bits and pieces in different replies 

Answer 4

You think it as 1000 concerent users.

 Then.......?

Answer 5

Huge user , memory issue

 

However cookies are not safe.