MySQL vs FoxPro

[Anon]

hi,

can anyone enlighten me about the advantages/disadvantages of mysql vs foxpro other than the speed?

i want to use a database of 2-3 million rows but just 8-10 columns. no relational stuff needed. which should i go for mysql or foxpro? the environment is going to be windows.

steve

[sarahk]

You might find that the design tools for foxpro (assuming you're talking visual FP) are better than the gui's I've used for MySQL.

What are you storing that it's not relational? I guess you're talking a single table rather than a database.

You might still find that the views available in fox (again assuming vfp) can help speed your queries. That's alot of records.

Say you're storing news items and the user wants the last weeks. I'd then query the view called news7days. You would probably get better performance through a view than through a straight query on a table. Easy to prove using seconds().

I'll be following this posting as I'm interested to see other opinions.

[Anon]

I have never used mysql. One thing that might help in determining this; what are you going to be doing with these records? Probably seeking, reporting, updating and so forth? If you go with Foxpro, make sure to create indexes for each field and also an index on deleted().