Speed of an Insertion

[erickwidya]

...to execute on my PC where the database table already has more than 2.000.000 records.

try BULK INSERT instead and remove the index while inserting then re-index again..i'm not sure how but i read somewhere to use that kind of method

and using Unicode datatype tooks 2 time more processing then using non-Unicode..i read it somewhere too

if u figure it out, plz post the answer ok..

thx..