Hi!
Given VFP's internals (I have to support FoxPro 2.6 apps, oh the pain of it all!),
MySQL should be capable of much better performance, considering the
only thing FoxPro has in terms of a possible advantage is Rushmore.
Which indexes do you have on the tables in the query?
Regards,
Chris
Indexes? hmmm... I knew those were useful for something :)
In Visual FoxPro I don't use indexes for this table... so I didn't considered them
necessary in MySQL (now I think I need to get to the basics of RDBMS).
This table I'm talking about is a CDR (call detail record), so a record represents
a call from a given telephone. I'm surely wrong but, ain't the index suppossed to be
on a field with distinct entries?
Does VFP automagically creates indexes depending on the query?
As you can see, I would greatly appreciate any pointers to some database theory.
Thanks again!
Hector
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
