Hi all, I want to do a vacuum on my table. Can any one tell me whether the below statement is the valid syntax for the vacuum command. How can we make sure that the command is really executing or not. Will there be any time difference if we do the vacuum for a table? I tried inserting some records with and without using the vacuum command, but there was not much time difference between the two.
sqlite3_exec (db, "vacuum (data_table)", NULL, NULL, NULL); Regards, Anish The information contained in, or attached to, this e-mail, contains confidential information and is intended solely for the use of the individual or entity to whom they are addressed and is subject to legal privilege. If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager. Please do not copy it for any purpose, or disclose its contents to any other person. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company. The recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email. www.aztecsoft.com