Re: [sqlite] Query - finding objects with given properties

Rich, You're certainly right. However I've actually simplified the table structure here in order to not over-complicate matters. I'm pretty certain the schema is good, but if you have the time/willingness to work through the whole thing with me, my AIM is NeonNinjaSan or ICQ 51549640 - I don't

Re: [sqlite] Query - finding objects with given properties

Igor, Thanks for the help! However, I'm running into an error with the sub-queries returning more than 1 result. I suppose it has to do with the fact that the property "hot" may have more than 1 entry (one for each object). Thanks! Igor Tandetnik wrote: > > select * from objects where > obj

[sqlite] Query - finding objects with given properties

I am attempting to write a query that runs as fast as humanly possible... to be honest, I'm having a really hard time even getting started with it. I'm generally decent with SQL but for some reason this one is eluding me in terms of doing it within a single query, which would help my application'

[sqlite] Query Optimization Help

Hello, I have a query that is slowing down my application significantly; in some cases, it takes 20+ seconds (this is in a SQLite database in an iPhone app, which is why it is so slow - the iPhone doesn't have as much system resources). If anybody could help me optimize this query, I'd appreciat