On 3 Jun 2011, at 12:47pm, Ian Hardingham wrote: > Common database operations: > > - select all of my non-completed matches > - select all of my matches > - select an old match to watch > - get my current friends
If any of these operations are slow, make sure you have indexes suited to your SELECTs. > - add/remove a friend Presumably your schema makes this one deletion of one row of one table. And you have a suitable index. > What is basically happening is that we're getting a fairly large number > of requests every second. Which SQLite library are you using ? For instance, are you calling SQLite from PHP ? If so, which API are you using ? Some are faster than others. > There is one specific activity which takes > about 2 seconds to resolve, which is finishing a match. This requires > an update to three separate tables. Do you do all three updates in a single transaction ? Oh, and congratulations on the popularity of your project. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
