Is it normal to have hundreds of rows updated in the BVC_Order table... where "LastUpdated" is less that a minute apart?


This website gets only 6 order per day.





does one row in BVC_Order = one order?



why would there be several rows a second?



Tom

Thanks Aaron,


That is most likely what is happening to my sites, since I am using the theme that you mentioned.



The guy that used to maintain these sites had some SQL that he used to run every so often, that deleted stuff from several tables,



if they were linked to the orders table and if the field "IsPlaced" = 0 and the order date was from a week ago.



My other problem is, that whenever I open up the code in Visual Web Developer - the sites go down.



this may be a "out of memory" problem or "out of diskspace" problem.



Tom