Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AS400 vs Visual Foxpro
- Thread starter PCMTECH
- Start date
alvechurchdata
Programmer
VFP is cheaper but it's impossible to say whether it'll do the job without knowing more.
How big?
How many users?
How many transactions?
How much security?
What are you converting from?
Do you need to integrate with Office or the Web?
Tell us more and someone will be able to give a detailed comparison.
Geoff Franklin
How big?
How many users?
How many transactions?
How much security?
What are you converting from?
Do you need to integrate with Office or the Web?
Tell us more and someone will be able to give a detailed comparison.
Geoff Franklin
- Thread starter
- #3
I have over 200 databases working well in fox 2.6
105,000+ records
over 600 users.
An average of 200 transactions a day.
I have made different applications with different types of security.
Revision contol is in place.
I'd be converting from foxpro 2.6 to the AS400.
IBM computers with xp and service pack 2.
Networked. The possiblity of having a web page would be desireable as we have many other locations around the world.
I have had no experience with programming in the AS400
I've been writing programs and creating databases and applications in foxpro 2.6.
I have seen visual foxpro 6.0 but I haven't had the time to learn how to program in it.
My IT group has been trying to discourage the green screen AS400 but my manager saw an application he liked.
I think he'd prefer a gooey screen. Which I understand there are ways to do that.
105,000+ records
over 600 users.
An average of 200 transactions a day.
I have made different applications with different types of security.
Revision contol is in place.
I'd be converting from foxpro 2.6 to the AS400.
IBM computers with xp and service pack 2.
Networked. The possiblity of having a web page would be desireable as we have many other locations around the world.
I have had no experience with programming in the AS400
I've been writing programs and creating databases and applications in foxpro 2.6.
I have seen visual foxpro 6.0 but I haven't had the time to learn how to program in it.
My IT group has been trying to discourage the green screen AS400 but my manager saw an application he liked.
I think he'd prefer a gooey screen. Which I understand there are ways to do that.
alvechurchdata
Programmer
The Fox 2.6 to AS400 would mean complete rewrite, stick with VFP. You'll still have to rewrite the user interface but all the tables, reports, and program logic can stay very much the same. You can also implement a phased changeover and share the same data files between old and new versions. If you run VFP 8 under XP then your screens can inherit the XP themes and your app will suddenly look brand new.
You posted this in the Fox 26 area. Have you had a look in the VFP discussions here? You might get more of a response there. Try Microsoft:VFP - Databases, SQL&VFP, and Reports.
Geoff Franklin
You posted this in the Fox 26 area. Have you had a look in the VFP discussions here? You might get more of a response there. Try Microsoft:VFP - Databases, SQL&VFP, and Reports.
Geoff Franklin
FoxPro was written in 16-bit code, whereas Visual FoxPro is written in 32-bit code. While there is technically some speed cost in the graphics overhead, leaving FoxPro will eliminate the ever-increasing compatibility and emulation issues with the newer operating systems and, besides, you will find that VFP is overall much faster than good old FP.
You can buy version 9.0 retail in February 2005 and is well worth it. Besides some new table data types and improved features similar to .NET you also get a vastly improved report form writer.
dbMark
You can buy version 9.0 retail in February 2005 and is well worth it. Besides some new table data types and improved features similar to .NET you also get a vastly improved report form writer.
dbMark
severach
Programmer
- Jan 10, 2005
- 49
>FoxPro was written in 16-bit code, whereas Visual FoxPro is written in 32-bit code.
FPD-286 is in 16 bit code but I think FPD-386 is fully 32 bit.
>you will find that VFP is overall much faster than good old FP.
What version did this start? My tests a long time ago showed that VFP3 was 30% slower than FPD26 so I stuck with FPD26 and only used the VFP's for a few screen based non data crunching operations. My tests also showed that FPD26 under NT2KXP is about 3x faster than FPD26 under Win9x on the same equipment. Testing on the wrong platform could be what shows FPD as a bad performer. I'd switch to a VFP if the performance can really stand up.
It's hard for me to believe that FPD lags as far as you say. I just developed a simple PHP+MySQL that uses large tables and I was able to run equivalent indexes, queries, and key searches on the same table style under WinXP on the same machine through Foxpro and MySQL. The speed was exactly the same though MySQL took substantially more RAM to perform properly. MySQL needs 150MB RAM to keep up with what Fox can do in 12MB. You're basically saying that VFP is faster than one of the heavyweights. I just need to know which version Microsoft decided to take seriously.
***
By the way, if the boss is willing to buy new equipment just to get a cool interface and you're considering rewriting the entire application, didn't anyone suggest making a web applicaton?
FPD-286 is in 16 bit code but I think FPD-386 is fully 32 bit.
>you will find that VFP is overall much faster than good old FP.
What version did this start? My tests a long time ago showed that VFP3 was 30% slower than FPD26 so I stuck with FPD26 and only used the VFP's for a few screen based non data crunching operations. My tests also showed that FPD26 under NT2KXP is about 3x faster than FPD26 under Win9x on the same equipment. Testing on the wrong platform could be what shows FPD as a bad performer. I'd switch to a VFP if the performance can really stand up.
It's hard for me to believe that FPD lags as far as you say. I just developed a simple PHP+MySQL that uses large tables and I was able to run equivalent indexes, queries, and key searches on the same table style under WinXP on the same machine through Foxpro and MySQL. The speed was exactly the same though MySQL took substantially more RAM to perform properly. MySQL needs 150MB RAM to keep up with what Fox can do in 12MB. You're basically saying that VFP is faster than one of the heavyweights. I just need to know which version Microsoft decided to take seriously.
***
By the way, if the boss is willing to buy new equipment just to get a cool interface and you're considering rewriting the entire application, didn't anyone suggest making a web applicaton?
- Status
