>> (though it's it considered obsolete now-a-days). This is only a consideration for the uni-formed or those that have never really used it. MS is still dumping lots of money into it. Just shipped v7.0 will be going into Beta with 8.0 in a couple of months.
Amazing String capabilties. As a matter of fact there is now a VFP style .net class that moves a lot of the wonderful commands internal to VFP to .NET. I think the Fox Dev team created. Cursor Technology, Rushmore Speed and many other things have moved there way into not only Access but SQL Server and ADO. Due to the fact that each part of a table is its own file. .DBF is the table. .FPT is the Memo field .CDX is the index. The file size limitation of the OS of 2 gig is at the individual file level. In Access everything is stored in the same file (you could break up but not really meant to) so the 2 gig file size is limited to the app and data which is more than likely in the same file. I have dealt with lots of situations where the .DBF was 1.8 gig, the index was 1.2 gig and the FPT was another 1+ gig size. Indexes are stored in a .CDX file. A .CDX file can have as many as 255 indexes (take into account 2 gig file size). Each open table can have 10 open CDX's so you can have 2550 indexes on a table. Very Robust SQL pass Through for back end databases. There is nothing out there as fast as VFP for pure raw speed. SQL 2000 gets close but not quite there, the advantage to SQL as far speed goes is it does not bog down under load. Load means 25 + heavy users. As far as speed goes I have seen the return of queries on tables as large as 21 million records within seconds and that was pulling data across a 10 meg network with Foxpro For DOS. United We Stand (remember Ross Perot) member/prospect database. Sounds a little dated but the point is its been that way in Fox for a long time. Fox and VFP managed/tracked the military assets to the Persian Gulf and is till in use. Manages the flow of info for Chunnel. It is far more prevalent than most realize. Very good OOP. It seems that VFP is becoming known for the best language that can really implement the "Abstract Factory Pattern" Very good interface. Rich Native Controls (No OCX) and does very well with OCX's. Easy Distribution. (Drop a couple of DLLS into system directory not reg) Rich Debugger. Can access any data ODBC, ADO or ADO.Net can access. Internal XML. Select Result set from SQL into a local cursor then use CURSORTOXML(). With the XMLTOCCURSOR() and CURSORTOXML() commands it is very easy to build thin wire apps. Bind the interface to the cursor. I can try any and all commands from the command prompt and even from within a debugging suspend. Pretty much interrogate the entire system at hand very easily from a suspend. Many options for hanging VFP behind IIS and ISAPI. You can create com objects and run behind other languages even from within SQL Server or visa versa. One of the most robust SOUNDEX/Fuzzy Search add-ons available with the PHDbase Library. You can index memo fields and do 2 - 3 second searches on huge amounts of memo data. Best Table Repair Libraries that I am aware of are available. Error trapping has been far superior to VB and a lot of languages since the Fox 2.0 days (1992). Last but not least http://www.universalthread.com. Great support from all over the world. obsolete...hmmmmm maybe lack of exposure or conflicting marketing problems with MS owning Access, SQL and Fox but certainly not obsolete. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sathish Chandrasekaran (S) Sent: Thursday, September 05, 2002 9:24 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: What database should I use In that case MS-access will be better on the size issue. But on the other hand if u want ur application to be flexible and ease of use I would rather suggest FoxPro (though it's it considered obsolete now-a-days). Here Is A Test To Know Whether The Mission Of Your Life Is Over . If You Are Alive It Isn't . Sathish C Infra-Amdocs -----Original Message----- From: A [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:21 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: What database should I use Hello, I am going to program a small application (in Python and wxPython) which consists about 2000 - 3000 records . Can you please recommend which database is the best for that. I use Windows. Maybe MS Access or FoxPro or MySQL or better? I want to keep the program as small as possible. Thanks Ladislav _______________________________________________ ActivePython mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython _______________________________________________ ActivePython mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython _______________________________________________ ActivePython mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython
