Mario *LigH* Rohkrämer
Guest
|
 Posted: Wed Aug 11, 2004 8:53 am Post subject: Re: tadotable.insert |
 |
|
"KonZa" <spam_me (AT) ciudad (DOT) com.ar> schrieb im Newsbeitrag
news:opscgo97quoy2s93 (AT) pchuevo (DOT) ..
| Quote: | hi there:
I wonder what will happend to the final table when doing an inserting in
the middle.
|
Please do not imagine a beginning, middle or end of a table.
TADOTable.Insert or SQL statement "INSERT INTO" will either append a dataset
row, or maybe overwrite a dataset row which was previously deleted and still
exists "tagged as deleted" to efficiently use database file space.
But most database management systems will definitely not move all the
remaining rows from the cursor forward to make space for a new row to be
inserted at the cursor - try to imagine the required time and amount of
harddisk access! (The only exception might be "clustered indexes" as
documented e.g. in MS SQL Server 2005 Abridged BOL, where the datasets will
become sorted by the value of that field(s).)
In general, in a database table, there is a native order of datasets, where
the database server found it most efficient to insert a dataset. Most
usually, new datasets are appended to a table's end (any other way would be
too time consuming).
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
