maximum number of rows in a sqlite database ? (to quering Efficiently) : I've Developed a data logger system with C , that read data from sensors and save the info taken in SQLite database.
Know my purpose is to reporting data from SQLite weekly .
In a period of one week about 900000 rows (each row has 4 columns) stored in SQLite table .

My main Question is :
Is it possible to query between this number of rows ? (900000 row)
And second problem is usage of RAM and CPU when query between 900000 rows !