| Author |
Real World Problem!
|
|
| Ioannis Stefis 2005-10-27, 8:34 am |
| Hi!
We are going to utilize VFP 9 to collect data from 20 departs in my country
to a central dbf table. The annual accruals of each depart estimated to 600
records. The table's structure must be collected has total width 4707 (Not
memo, blobs, pictures).
What about the capabilities of VFP 9 to handle such problems? How many years
can we safely collect the above data? Any experience appreciated!!!
Stefis Ioannis
| |
| Fred Taylor 2005-10-27, 8:34 am |
| Your total field size shouldn't be a problem (65,500 is the limit), so with
2GB maximum .DBF size, you should be able to store approximately 425,000
records. At 600 per year, the system should last you about 708 years. <bg>
--
Fred
Microsoft Visual FoxPro MVP
"Ioannis Stefis" <stefsin@otenet.gr> wrote in message
news:%23g1g0qLzFHA.1256@TK2MSFTNGP09.phx.gbl...
> Hi!
> We are going to utilize VFP 9 to collect data from 20 departs in my
> country
> to a central dbf table. The annual accruals of each depart estimated to
> 600
> records. The table's structure must be collected has total width 4707 (Not
> memo, blobs, pictures).
> What about the capabilities of VFP 9 to handle such problems? How many
> years
> can we safely collect the above data? Any experience appreciated!!!
>
> Stefis Ioannis
>
>
>
| |
| Anders 2005-10-27, 8:34 am |
| Dived by 20!
-Anders
"Fred Taylor" <ftaylor@mvps.org!REMOVE> skrev i meddelandet
news:uGyjQNOzFHA.1680@TK2MSFTNGP10.phx.gbl...
> Your total field size shouldn't be a problem (65,500 is the limit), so
> with 2GB maximum .DBF size, you should be able to store approximately
> 425,000 records. At 600 per year, the system should last you about 708
> years. <bg>
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Ioannis Stefis" <stefsin@otenet.gr> wrote in message
> news:%23g1g0qLzFHA.1256@TK2MSFTNGP09.phx.gbl...
>
>
| |
|
| foxpro should have no problem with that amount of data.
you can also always upsize to sql server if you outgrow.
most important should be your design of table structures that they are
truly relational and data is not duplicated in more than one table.
Ioannis Stefis wrote:
> Hi!
> We are going to utilize VFP 9 to collect data from 20 departs in my country
> to a central dbf table. The annual accruals of each depart estimated to 600
> records. The table's structure must be collected has total width 4707 (Not
> memo, blobs, pictures).
> What about the capabilities of VFP 9 to handle such problems? How many years
> can we safely collect the above data? Any experience appreciated!!!
>
> Stefis Ioannis
>
>
>
| |
| Fred Taylor 2005-10-27, 8:34 am |
| Correct. I missed the "each department" part. 35 years is still plenty, I
would think.
--
Fred
Microsoft Visual FoxPro MVP
"Anders" <anders@anders> wrote in message
news:eiOttXPzFHA.1028@TK2MSFTNGP12.phx.gbl...
> Dived by 20!
>
> -Anders
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> skrev i meddelandet
> news:uGyjQNOzFHA.1680@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Ioannis Stefis 2005-10-27, 8:34 am |
| Thanks a lot to all! I am very happy!
Regards!
| |
| Rush Strong 2005-10-27, 8:34 am |
| Is that allowing for the Y2.4K bug?
- Rush
"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:uGyjQNOzFHA.1680@TK2MSFTNGP10.phx.gbl...
> Your total field size shouldn't be a problem (65,500 is the limit), so
> with 2GB maximum .DBF size, you should be able to store approximately
> 425,000 records. At 600 per year, the system should last you about 708
> years. <bg>
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Ioannis Stefis" <stefsin@otenet.gr> wrote in message
> news:%23g1g0qLzFHA.1256@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Stephen Ibbs 2005-10-27, 8:34 am |
| Microsoft have scheduled a patch release for Vista SuperPlus Pro 14th
Edition to deal with this feature, due for release in 2403
Stephen
"Rush Strong" <rush.strong]@[verizon.net> wrote in message
news:%23XQ%23nRD0FHA
.2752@TK2MSFTNGP12.phx.gbl...
> Is that allowing for the Y2.4K bug?
>
> - Rush
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:uGyjQNOzFHA.1680@TK2MSFTNGP10.phx.gbl...
>
>
| |
|
| Just remember that you will have to manually patch your data tables and
search routines for the time between 2400 and 2403. <G>
Ted
"Stephen Ibbs" <stephen@ibbs.org.uk> wrote in message
news:eLG44oD0FHA.2132@TK2MSFTNGP15.phx.gbl...
> Microsoft have scheduled a patch release for Vista SuperPlus Pro 14th
> Edition to deal with this feature, due for release in 2403
>
> Stephen
>
> "Rush Strong" <rush.strong]@[verizon.net> wrote in message
> news:%23XQ%23nRD0FHA
.2752@TK2MSFTNGP12.phx.gbl...
to[color=darkred]
>
>
|
|
|
|