Hi,
My application need to import a lot of record from a text file... For the import, all
is ok, but for performance and time reasons (more that 8000 records) I delete all the
current records in database and re-inport all instead of comparing and updating (how
to update with no primary key in text file ? I must to compare all fields together !?
It is already slow, i don't want to make my application slower !). anyway, This is not
important, It work as it is.
But, my problem is : After 10 times i do the import, the database, who has a initially
size of 300k is now more than 20Mb !!
My question is : Is it possible to compact this database by a function, a query or a
tag instead of downloading base from the server, open it in access and then reupload
it on the server (fasctidious).
Thanks for help !!! And excuse my english.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
