Welcome, Guest ( Customer Panel | Login )




 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  

skynet104
VP-CART New User

94 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.-

rustytec
VP-CART New User

Australia
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:
http://www.bigyellowzone.com/shopexd.asp?id=114

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.

or:

"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.

cheers

Russ
rustytec




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