Not sure if this would help with the size, but it may help a lot with
speed: (in sql server at least - not sure if it works with access)
Try using:
truncate table tablename
instead of:
delete from tablename
Al Musella, DPM
A1webs.com
At 12:58 PM 2/8/2001 +0100, you wrote:
>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
