Hi everyone, I am facing a issue and details are as below:
1) Database table have around 15 table. One of the table have around 66000 entries and this table have about 25 columns. 2) This table with 66000 entry have field called TITLE with TEXT type with table name AUDIO. 3) When I run a query like: SELECT TITLE FROM AUDIO WHERE VALID!=0 ORDER BY TITLE ASC; (here VALID is also a column), sqlite3_step() is returning error SQLITE_FULL. 4) Database is created in a tempfs path with 64MB space (This is tmpfs is not a default one it is created only for the database creation). And default tempfs have 2MB of space. 5) Created database size is at around 7.5MB. please can anyone help me in understanding how this query works? Is this error is due to no enough cache space for database to prepare the query? Please help me in resolving this problem. Thanks. Thanks and Regards Deepak