Hello, I am in need for a database to hold a couple of tables with max 10,000 rows each that I will update frequently and query frequently.
Example, 5000 users connect to our server every 10 seconds and each time they connect, I need to update a table with their IP and Last_connect_time. Also, every 10 seconds or so, a couple of hundred users will query this table with simple select statements (Select ip from table1 where last_connect_time is greater than 20seconds). I'm trying to choose the most efficient db for this application and my main criteria is response time. Will SQLite do this more efficiently than SQL Server. I'm planning to allocate upto 1GB memory. I appreciate any input we can give on this. Robel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
