Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incredible performance degration behaviour
Message
From
14/01/2005 03:21:39
 
 
To
14/01/2005 02:05:08
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
00976753
Message ID:
00977072
Views:
37
>Hi Fabio,
>
>>The dogma:
>>If a developer open 100 workareas is not VFP slow,
>>but the developer is incapable, surely .
>>We can do anything with max 10 workareas !
>
>
>Well then classify me as incapable. I've got one or two forms that might contain 100 occupied workareas. Remember that if you're using local SQL views, you'll have one workarea for the view and one for each underlying table, rappidly increasing the number of workareas when opening more view.
>
>In another instance, I've got a query designer that *might* generate a cursor for each column that is requested. If the users have a very complex query, the number of workareas might increase rapidly. It was exactly in this query designer where I spotted the problem. It was taking too much time to construct a result cursor out of several others as I found justifyable based on the code and number of iterations.
>
>To be honest. I'd be seriously crippled with only 10 workareas. I've got queries that on their own already open 10 workareas.
>
>Walter,

Hi Walter,

Of course i Agree.
Which sense has, to be able to allot 32XXX workareas for datasession,
if allotting 10000 the program slows down of 500 times the performances?

But every time i write that a developer environment have various issues when a developer uses many resources,
someone write:
"Hey, you are incapable,
you have not necessary of these resources,
you can do the job with a little fraction of these"

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform