Hey guys, once again sorry for spamming at the moment. This is a simple question.
My user account table has a field "isOnline INT". This table has, say, 100,000 rows. Every ten seconds I need to compile a list of all users where isOnline is 1. However, people log in and out at a rate of about 10 a second, so I'm updating the account table 10 times a second. The question - should I put an index on isOnline or not? I'm very worried about such an often-run transaction as logging in and out be as fast as possible. Thanks, Ian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
