Fastest way to delete records
in [Visual Objects]
|
From: Stephen Quinn on 4 Feb 2010 08:38 Martin > Better than :Delete()? Better than a while loop at least (which is what you need to do to use :Delete()<g> I'll leave the testing to you as I don't have a 6GB file to test it on<bg> You might try killing the notify messages before executing the line or your loop. CYA Steve
From: Joachim Duerr (ADS) on 4 Feb 2010 09:17 Martin wrote: >Is there a direct ask server to do the delete rather than client >option? SQL: delete from table where condition -- Joachim Duerr Advantage Presales check out my new ADS book on http://www.jd-engineering.de/adsbuch
From: Martin on 4 Feb 2010 09:24 SuspendNotifcation done after opening "Stephen Quinn" <stevejqNO(a)bigpondSPAM.net.au> wrote in message news:v5Aan.5586$pv.4660(a)news-server.bigpond.net.au... > Martin > >> Better than :Delete()? > Better than a while loop at least (which is what you need to do to use > :Delete()<g> > > I'll leave the testing to you as I don't have a 6GB file to test it on<bg> > > You might try killing the notify messages before executing the line or > your loop. > > CYA > Steve >
From: Martin on 4 Feb 2010 09:25 I have never done SQL from VO, have you got any samples please? "Joachim Duerr (ADS)" <jojo.duerr(a)gmx.de> wrote in message news:7t0380Ff68U1(a)mid.individual.net... > Martin wrote: > >>Is there a direct ask server to do the delete rather than client >>option? > > SQL: delete from table where condition > > -- > Joachim Duerr > Advantage Presales > check out my new ADS book on http://www.jd-engineering.de/adsbuch
From: Geoff Schaller on 4 Feb 2010 16:46
Whether it is ADS or MS I don't care. Delete using SQL is rather quick. Delete mytbable where balance>0 No loop, one statement, very fast. Geoff "Martin" <spam(a)spam.spam> wrote in message news:%Byan.14539$MQ6.13026(a)newsfe16.ams2: > That is a future answer, still currently a couple of CLipper apps and a > Xbase++ app to look at > > > "oscar hernandez" <ohernandez(a)liasa.com> wrote in message > news:65c45340-a350-4e87-91d0-05c1dd98d225(a)v25g2000yqk.googlegroups.com... > use ADT instead of DBF, it will reuse the deleted record > automatically, You do not need to pack. > > > On Feb 2, 3:15 pm, "Geoff Schaller" > <geo...(a)softxwareobjectives.com.au> wrote: > > > Move to SQL <g>. > > > > "Martin" <s...(a)spam.spam> wrote in message > > > > news:1zX9n.262479$FH.149151(a)newsfe03.ams2: > > > > > > > > > > I need to trim a file a lot as quickly as possible of certain records. > > > > > File is roughly 6GB > > > > > Production build is 2.7, Server is ADS 7.1, going to 9 next week. > > > > > Testing with 2.8 and ADS 8.1, 4% on my PC and 15% on the "server". > > > > > This is the current code and does about 750 records a second for delete. > > > > > SELF:dbBarList:SetOrder(3) > > > SELF:dbBarList:Seek('19900101',TRUE) > > > SELF:dbBarList:Delete(,{||_FIELD->PL_PDate <= dClear}) > > > SELF:dbBarList:Pack() > > > > > Can anyone think of a way of speeding this up? (Not including my > > > favourite > > > of using a different NOS) > > > > > What is the RDD doing via ADS? > > > > > Thanks > > > > > Martin- Hide quoted text - > > > > > - Show quoted text - |