Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sudden slow database access
Message
From
19/01/2015 11:40:31
 
 
To
19/01/2015 11:25:24
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01613560
Message ID:
01613903
Views:
55
Dragan, Thanks.

This is just an "aside" to the main conversation. I am trying to understand your post.

Are you telling me that if my views had no joins and instead I simply pulled each tables data that is needed separately, then using cursors somehow end up with the same data as I was pulling with a view that contained joins, I would be a lot faster?

If that is what you are saying, I understand. In the testing I have done I have noticed, I can pull a million records from a table with no joins in just a few seconds. Add even the simplest join (on indexed fields) and it will almost always, if not always, be many times slower.

All that said, with 1000 views and 80% of those views having at least 1 join, that would seem to be an impossible task.

Thanks for any clarification,
John
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform