Re: FoxPro vs. Informix

From Peter Wiley - Poultry: * In article <thatcher.10.2F4BA2FC@edge.ercnet.com> thatcher@edge.ercnet.com (Tom Hatcher ) writes: * >Could anyone help explain why Foxpro running on a Pentium base PC is able * >to populate a 40MB database in 1 minute and it takes Informix 6.0 running on a * >dual processor Spark 1000 server 10 minutes? * > * >Thanks * >Tim H. * > * * I bet I could write a C program that could beat Foxpro :) * * While I can't explain the speed difference, you need to keep in mind that Fox * isn't doing any of the transaction processing/logging that Informix is, nor is * it running a server process to control database access. Speed isn't everything * * If you don't believe me, try running an update statement on a table with over * a million rows and kill the power to the computer in the middle. I'll bet that * the Fox database is totally hosed. Only if your lame enough to not program with transactions. [stuff deleted] Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) De Colores - Emmaus OC-13 | Fax: 714.771.3028 | \\`-'/ #include <disclaimer.h> SURF'S UP \\_/