subject:"\[sqlite\] faster query \- help"

Re: [sqlite] faster query - help

2013-01-25 Thread Igor Tandetnik

On 1/25/2013 9:45 AM, moti lahiani wrote: 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

Re: [sqlite] faster query - help

2013-01-25 Thread Michael Black

first before the join when it can? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of moti lahiani Sent: Friday, January 25, 2013 8:45 AM To: sqlite-users@sqlite.org Subject: [sqlite] faster query - help Hi I have a data base