VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 How to erase search results table..
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

92 Posts

Posted - September 13 2006 :  16:40:24  Show Profile  Reply with Quote
Hi there:

My search results log table became to big, more then 60,000 records how can i delete the data in it.

is there query of something that can help?

Thanks in advance.-

VP-ASP New User

113 Posts

Posted - September 13 2006 :  17:28:50  Show Profile  Reply with Quote
Hi skynet104,

You could run an SQL delete query that will remove the records from the table.

BYZ has a freebie Advanced SQL Execution tool that will allow you to do it. Becareful though, it is very powerful and there is no return from any action done.

You can find it from these great guys at:

You would probably run the following to remove the full contents of the table:

"Delete * from searchresults" ~(without the "'s)

or if you only wanted to remove up to a certain ID or date :

"Delete * from searchresults where ID < 40000" ~(without the "'s)

- just edit the '40000' to be whatever amount of records you want to delete.


"Delete * from searchresults where rdate <= #21/08/2006#" ~(without the "'s)

The only thing if the database is an access database then the records are removed, but the database still holds a 'memory' of deleted records until it is compacted. SQL does not have this problem.

With an access database you might need to download it in the end and run a compact. It is mentioned in other posts, however that on occassions running a compact may reset the internal table counters.

Best check with support on this prior to running a compact, but the above SQL will certainly remove the records.



Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000