| David Fishburn 2005-05-20, 3:24 am |
| handheldmaster wrote in news:428cc2a7.1a3f.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
h> My dev env => Ultralite 8.0.2(4392) - MVB 3.5 (0633)
h>
h> Wanted to know is there any difference how
h> Table.DeleteAllRows runs v/s Table.Truncate
h>
h> Which would be faster on the Pocket PC ? Specially when
h> doing large number of records almost 2000+ records stored in
h> temporary tables.
Generally TRUNCATE TABLE is faster.
Your best bet is to populate a table, and try some timing tests.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|