Re: FoxPro vs. Informix

Tom Hatcher (thatcher@edge.ercnet.com) wrote: : 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? To answer this question, more information is necessary about the structures of the databases and the indexes and of course about the data themselves. Are the two DBs the same? What is the performance of the two DBs when complex queries are run against them? How many users are connected to each? What other processes were running on the Sparc at the time of loading? Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+