Hi all,
I am using prepared statement for insertion and retrieval of
records to and from the database. The time it takes to insert and
retrieve 10,00,000 records varies in different trials. The time for
different trials are as follows.
For inserting 16 byte string the time taken are 14.850797,
17.057271, 17.637058, 19.796403, 17.503216.
For retrieving 10,00,000 records randomly, time taken are,
50.308758, 48.103936, 49.521511, 49.227987, 45.499152.
I would like to know y this time difference showing. I am using the
following code for calculating the time.
start_time = getTime();
sqlite3_step(insert);
end_time = getTime();
where getTime is the function which returns the time in microseconds.
With Regards,
Anish Enos Mathew
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
