Aqlite is not the DB for your application. You need a server like PostgreSQL or Oracle.
Robel Girma wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users