mardi 23 juin 2015

Sorting data from SQLite with queries or using programming language

I'm creating XUL app which uses SQLite database for storing data. Which is the better practice to sort and display data from DB to users - using queries such as:

SELECT * FROM table WHERE this=that AND...

or to simply get the data from DB with simple query like

SELECT * FROM table 

and then sort it with whatever programming lang you are working with(in my case JavaScript). By better I'mean faster, safer and simpler?

Aucun commentaire:

Enregistrer un commentaire