Hi I have a data base with the following tables 1) files - each file in the system have his information in this table. that table include 12 different columns like file_id as integer primary key autoincrement, date_uploaded as integer, file_type as integer and so.. 2) music_files - hold more information on file in case the file is music file. columns like file_id as integer, artist, genre, album_name and more
I need to query those 2 tables (with both all information) according to some filters/rule that I have, order the results according to date_uploaded and return the top(10) as final result my question is what is faster and have the best performance: (the table files can have more than 1500000 rows) option 1: select the file_id and date_uploaded, order by date_uploaded and get the top(10) file_id and than select all information from both(files and music_files) tables according to those top(10) results option 2: select all information from both(files+music files) tables, order by date_uploaded and return the top(10) as results Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
