MySQL Forums
Forum List  »  Microsoft Access

Re: Beginning and end of table
Posted by: Peter Brawley
Date: March 28, 2018 08:35PM

> I have three different "ORDERS" for data implemented
> through ALTER TABLE mytable ORDER BY myfield ASC etc.

Dreadfully wrong practice. Grotesquely inefficient. Physical row order survives only until the next update or Insert. A basic rule of relational databases is that row order presentation is independent of physical storage. The physical ordering kludge you are using is for occasional use when other optimisation methods fail.

To order row display, use queries with Order By clauses, optimise them correctly for performance, use Where or Limit clauses to paginate, and write code to keep track of which row the user is in her browsing.

Options: ReplyQuote

Written By
March 28, 2018 12:24PM
March 28, 2018 01:07PM
March 28, 2018 05:13PM
Re: Beginning and end of table
March 28, 2018 08:35PM
March 29, 2018 06:05AM
March 29, 2018 06:34AM
March 29, 2018 07:00AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.