Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 Database Issues
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sansond
Starting Member

5 Posts

Posted - March 11 2002 :  03:30:53  Show Profile  Reply with Quote
I am using vpasp 4.0 with Access 2000 database. When I use the import utility to update prices and descriptions on my site I am seeing the database grow double or triple in size. Does anyone know why this is happening and is this going to cause a problem? Is there a fix?

Thanks,
-Devin

foley
Starting Member

11 Posts

Posted - August 09 2003 :  23:51:18  Show Profile  Reply with Quote
what is needed here is an asp script to compact the database online. I came across one sometimes ago, but cant remember where again.Any one has a clue about such a script?

Go to Top of Page

foley
Starting Member

11 Posts

Posted - August 10 2003 :  00:16:26  Show Profile  Reply with Quote
I knew I had come across this somewhere on the net. Here is the link to the script.

http://aspalliance.com/mbrink1111/compact.asp

Hope it works for you. Let us know of your experiences if you use it. I will be trying to implement it myself.



Go to Top of Page

Jill
VP-CART Super User

USA
249 Posts

Posted - August 10 2003 :  00:24:05  Show Profile  Reply with Quote
I wonder what happens if there are any users while the database is being compacted?

Jill

Go to Top of Page

GTM
VP-CART New User

USA
122 Posts

Posted - August 10 2003 :  21:32:06  Show Profile  Reply with Quote
They get compacted.

Greg

Go to Top of Page

Jill
VP-CART Super User

USA
249 Posts

Posted - August 10 2003 :  21:59:00  Show Profile  Reply with Quote
Then I want to be one of the users!

Go to Top of Page

admin
Starting Member

USA
6 Posts

Posted - August 11 2003 :  05:15:08  Show Profile  Reply with Quote
DIT CON ME CHUNG MAY
[email protected]

Go to Top of Page

searley
VP-CART New User

169 Posts

Posted - August 13 2003 :  05:01:29  Show Profile  Reply with Quote
I have an asp script for compacting the database server side, it works great, should anyone want it let me know and i'll put it somewhere for download!

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00