Dear All, We have a table named Brand(data is not ordered by Branddescription) where BrandDescription is one of the column and we tried to copy the Brand with the same stucture with the table name Brand_temp and inserted the data ordered by BrandDescription into a temp table as follows: CREATE TABLE Brand_temp AS SELECT * FROM Brand WHERE 1=2 insert into Brand_temp select * from brand order by branddescription
Then we dropped the Brand table and renamed the temp table as brand like as follows: Drop table Brand ALTER table brand_temp RENAME TO Brand When we tried with the original Brand Table in the application it is taking around 15 minutes to fetch the record. But when we use the temp table it's taking 11 secs to fetch the record. We are not clear why there is a drastic change in fetching the records since the structure remains the same and we are using the same application for fetching the records from both the table. Kindly clarify us in this regard. Thanks in advance. Regards, Farzana. -- View this message in context: http://www.nabble.com/Fetching-records-from-Temp-table-tp17399000p17399000.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
