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


Subject
Views
Written By
Posted
289
March 28, 2018 12:24PM
186
March 28, 2018 01:07PM
221
March 28, 2018 05:13PM
Re: Beginning and end of table
234
March 28, 2018 08:35PM
215
March 29, 2018 06:05AM
187
March 29, 2018 06:34AM
236
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.