Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #812
| 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> |
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
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