[sqlite] How to speed up a query between two tables?

[Kermit Mei]

Hello community!

I have two tables:

HomeDev(id, text, icon)

and

ZPhDev(id,HomeDevId)

Now, I must usually access(read-only) the items:

sqlite> SELECT HomeDev.text, ZPhDev.id
   ...> FROM ZPhDev
   ...> INNER JOIN HomeDev ON (HomeDev.id = ZPhDev.id)
   ...> ORDER By HomeDev.text;


Then, How can I speed up this kind of operation?  Use view like this:

sqlite> CREATE VIEW ZHview AS
   ...> SELECT HomeDev.text, ZPhDev.id
   ...> FROM ZPhDev
   ...> INNER JOIN HomeDev ON (HomeDev.id = ZPhDev.id)
   ...> ORDER By HomeDev.text;

And can it speed up my operation?

Thanks.
Kermit Mei


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users