Suggestion 1: port to a more industrial DBMS. :-) Suggestion 2: try creating some hash of the key values that you need to delete. If the size of the delete chunk is what's choking the server, reduce the size of the choking chunk by spewing more and smaller chunks.
Pretty disgusting suggestion for a Sunday evening, but there it is... ;-) --IronFury "Palyne Gaenir" wrote > > Since y'all have been immensely helpful (and my most grateful thanks) a couple times > recently, I will try sending my current Biggest Problem to the list. > > I am publicly hosted. There is a query-timeout value which a number of my on-site > pages(reports) are now exceeding. To see if I could bring the time down, I added some > indexes to the table, which has 50,000 records, and attempted to delete a bunch of old > records to make the table smaller. > > If I run a regular delete statement, the query times out. So I can't even delete records. > > When I tried to make it a stored procedure, it chronically error'd, even when my server > rep himself attempted to make it (everyone assures me this is 'easy' and nobody can do > it, why is that...); when I implemented a code suggestion from this list, the system then > told me my table didn't exist. My rep says this means I don't 'own' the table, but I'm > using owner "dbo" value in the SP and do have the DS name, which I was told is all > proper. > > So I have this table and I can't do a damned thing with it. I can't delete records to make > it smaller; I can't run reports on it because apparently it is too big, if even the simplest > delete statement times out. Alleged experts can't get get a 6-word query to work as a > SP on it. And I have customers (college instructors) ranting because they can't get > reports on what their students are doing. I have no idea what to do at this point. Any > suggestions would be greatly appreciated. > > Palyne > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Palyne Gaenir > Science Horizon Web Media > www.sciencehorizon.com > [EMAIL PROTECTED] > cel 918.533.3765 tf 877.316.0763 > > > > > ------------------------------------------------------------------------- > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
