Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 To: Glen Villar
  Where is Glen Villar?
 Palayan City
 Philippines
 Glen Villar
 Tags
Subject: RE: adding data to dbf
Thread ID: 188403 Message ID: 188910 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, August 12, 2008 3:27:34 PM         
   


> >
> >
> >
> > Glenn,
> > my point is that you want to pack on a daily basis. I presume you pack because you dont want unwanted records in your table. These unwanted records I call datamurmur, I believe, but once more that is only an opinion, you should not have allowed to enter those numerous datamurmur fields and you could consider to review your dataentry logic to prevent this. More strongly I am a favourite to avoid by anymeans that tables are loaded with records which are useless and need to be removed daily.
> > Regards,
> > Koen
>
> Hi Koen,
>
> Now I understand you clearly. But the fact that I include pack in my EOD doesn't mean I have too much erronous entries in my tables which should bring my attention to review my dataentry logic. That is your opinion and I respect that, but I think you have mistaken my practice of performing pack at the end-of-the-day as an act to rid my table of too much incurred erroneous entries. I'm just clarifying that my EOD is included with packing a table even if that table contains only one marked record to permanently delete. I'm doing this to prepare the table for another fresh transaction for another day.
>
> Whether I issue pack on weekly or monthly basis, I don't quite see a difference but just allowing the marked entries to remain in the table in a span respective to the duration until removed by pack. Another difference I see there is that I have longer time to assess whether those erroneous entries are to remain or to be removed and I have more time to place them into my history table for assessment than with the daily basis.
>
> However, as I've said I am not closing my door to this issue. I have not tried using pack command on tables with a million record yet to see if it will affect the performance. But I am nevertheless, convinced it will. :-)
>
>
>
>
> (coffee)



Hi,
Glad to hear I made my point clear.
Best regards,
Koen

ENTIRE THREAD

adding data to dbf Posted by donyx hernan @ 8/9/2008 12:43:43 PM
RE: adding data to dbf Posted by tushar @ 8/9/2008 1:31:35 PM
RE: adding data to dbf Posted by surinder singh @ 8/9/2008 2:42:18 PM
RE: adding data to dbf Posted by donyx hernan @ 8/10/2008 6:50:37 AM
RE: adding data to dbf Posted by Jim Booth @ 8/10/2008 3:38:31 AM
RE: adding data to dbf Posted by Glenn Villar @ 8/10/2008 4:46:18 AM
RE: adding data to dbf Posted by Mike Yearwood @ 8/10/2008 1:04:50 PM
RE: adding data to dbf Posted by Glenn Villar @ 8/11/2008 3:08:59 AM
RE: adding data to dbf Posted by Koen Piller @ 8/11/2008 7:52:04 AM
RE: adding data to dbf Posted by Glenn Villar @ 8/11/2008 8:22:55 AM
RE: adding data to dbf Posted by Koen Piller @ 8/11/2008 8:54:56 AM
RE: adding data to dbf Posted by Glenn Villar @ 8/11/2008 9:05:43 AM
RE: adding data to dbf Posted by Koen Piller @ 8/12/2008 7:57:28 AM
RE: adding data to dbf Posted by Glenn Villar @ 8/12/2008 8:34:45 AM
RE: adding data to dbf Posted by Koen Piller @ 8/12/2008 3:27:34 PM