I have a large table, about 1.5GB with an index on invno which is a char 6. Files are on a file server, client machine where I am running VFP6 and VFP9 is connected via gigabit ethernet.
I run SELECT * FROM invoicdt WHERE invno = '989426' In VFP6 it takes about 6 seconds. In VFP9 it takes about 60 seconds. Anybody have any idea why it is so much slower in VFP9? -- Jeff Roberts | jefflrobe...@gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAMandq8=gdlcrbpudycam8ugq8st5tewkd-6pvpipbarz2s...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
