Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #812

Re: DBF file grows very huge -Gigabits...

From "Jamal" <vodotnet_nospam@yahoo.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: DBF file grows very huge -Gigabits...
Date 2011-04-11 22:12 -0400
Organization A noiseless patient Spider
Message-ID <io0cf4$l1b$1@dont-email.me> (permalink)
References <inv1gk$h33$1@dont-email.me> <4da380c8$0$33413$c30e37c6@exi-reader.telstra.net>

Show all headers | View raw


Geoff,

I sent you an email regarding the SQL conversion.

Jamal

"Geoff Schaller"  wrote in message 
news:4da380c8$0$33413$c30e37c6@exi-reader.telstra.net...

Jamal,

Define "big" app. And don't you draw revenue from the application? Isn't
it important to the user? We all had big apps and we all have made the
jump to SQL and we are all rather glad we did. (We = about 30 VO users I
know).

I also remain unconvinced DBF itself is the cause. If it is one table I
still suspect some errant process in your code. Network and AV oriented
issues cannot be table specific... I hope you get my point.

But I think you should go SQL.

Geoff

PS - just for info. We have almost finished converting a very old DBF
app (full of DBxxxx stuff in parallel with DBServer). Here is some scale
for you:

40+ tables (not including the archive ones)
60+ indexes
90 menu entries to processes and windows
38 browser windows (that also had databrowser replaced with bbrowser)
82 data entry windows (some with 60+ controls - 26 also with sub
browsers)
Untold dialogs, popups, processes and functions.

I don't know if you classify this as big or not but it is not
insignificant. Took about 140 hrs to convert fully to SQL (not including
reports) and we were able to axe around 80,000 lines of redundant code.
The hrs include the code to uplift and manage the DBF data to SQL and
various support mechanisms. Jamal, it can be done.


"Jamal" <vodotnet_nospam@yahoo.com> wrote in message
news:inv1gk$h33$1@dont-email.me:

> Disaster struck again!
>
> This happened again to another user who did not backup his data for at 
> least
> 1 month!
> The file grew to 4 GIG, the DBF structure was OK, data totally corrupted
> with a lot of blank spaces. It was zipped to to only 14 MB.
>
> It's high time to move away from DBF to SQL but this a big application.
>
> Jamal
>
>
> "Jamal"  wrote in message news:ikoh77$lpc$1@news.eternal-september.org...
>
> Hi,
>
> It happened to a few locations that a DBF file grew to over 4 GB. Trying 
> to
> see if it has any records was a futile attempt as I could not open the 
> file.
>
> What could cause a sudden increase in the file size to that large size 
> when
> it should have been 50 MB or so?
>
> I am using the DBFCDX driver and VO 2.8 SP3. It never happened before SP3;
> not sure if this has anything to do with it or if it something else.
>
> Jamal 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Re: DBF file grows very huge -Gigabits... "Jamal" <vodotnet_nospam@yahoo.com> - 2011-04-11 09:59 -0400
  Re: DBF file grows very huge -Gigabits... dlzc <dlzc1@cox.net> - 2011-04-11 09:20 -0700
    Re: DBF file grows very huge -Gigabits... "Jamal" <vodotnet_nospam@yahoo.com> - 2011-04-11 14:18 -0400
      Re: DBF file grows very huge -Gigabits... dlzc <dlzc1@cox.net> - 2011-04-12 07:50 -0700
        Re: DBF file grows very huge -Gigabits... "Jamal" <vodotnet_nospam@yahoo.com> - 2011-04-12 16:52 -0400
          Re: DBF file grows very huge -Gigabits... pete.warshter@gmail.com - 2013-09-08 06:57 -0700
            Re: DBF file grows very huge -Gigabits... Martin <spam@spam.spam> - 2013-09-12 09:06 +0100
  Re: DBF file grows very huge -Gigabits... "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-04-11 22:29 +0000
    Re: DBF file grows very huge -Gigabits... "Jamal" <vodotnet_nospam@yahoo.com> - 2011-04-11 22:12 -0400

csiph-web