foxpro question?

Question

which is faster in foxpro, in terms of speed, efficiency, memory mgmt. etc..
creating a table or creating a cursor, also
are there any sites available for foxpro other than msdn, i mean a rich source of foxpro
lastly, why does my sql syntax->
select * from ormstr where ordate=dFrom order by orno into cursor ormstrtemp
takes almost two minutes to finish the query?
thanks and looking forward

Answer 1

1. follow the advice of bdloving

2. once orddate is index (index on ordate tag orddate), be sure order is set to "0". set order to 0

3. then issue your command.



FoxPro (old and new) uses Rushmore Technology. Google "Rushmore" and you will find numerous articles about how to properly use it. Most queries will come back in seconds if properly constructed.

Answer 2

well 1st of all, is Ordate indexed? you are selecting based on that field.

2nd, dont bother with the order by orno unless you need the results in that order.

3rd do you need ALL the fields from the ormstr table, if not, specify only the fields you need instead of Select *



speed = cursor

memory mgmt = table

depends on what you plan to do with the resulting tableset.

Answer 3

FoxPro is a database management system which is updated edition of Dbase III plus. You can compare the FoxPro system with DB2, Oracle or any other DBMS system. I belive Visual FoxPro is a latest edition FoxPro. Hope this helps.