RE: Attention Chris Davis - speed issue on Server 2012.

Thanks Alan, we will give this a try. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 23 June 2017 11:36 To: profoxt...@leafe.com Subject: Attention Chris Davis - speed issue on Server 2012. I knew this rang a bell and I managed

Re: Attention Chris Davis - speed issue on Server 2012.

On Fri, Jun 23, 2017 at 6:35 AM, Alan Bourke wrote: > I knew this rang a bell and I managed to find an email I got a while > back about another person with a similar issue, it might help: "Fair Share" -- what a great Microsoft-ism: everyone gets mediocre performance so

Attention Chris Davis - speed issue on Server 2012.

I knew this rang a bell and I managed to find an email I got a while back about another person with a similar issue, it might help: *Windows 2012R2 and slow VFP (Visual FoxPro database) applications* We recently had a customer where we implemented a Windows 2012R2, Citrix XenApp 7.5 environment

Re: Speed

, September 12, 2012 3:50 PM Subject: Re: Speed If I've been following this correctly, the speed is good when processed locally (on the same machine?) but slow most of the time when a network is involved although not always slow. I wouldn't point the finger at the server, nor the workstation

Re: Speed

On 9/14/2012 7:28 AM, Michael Madigan wrote: My software is too optimized, I have a gazillion index tags, which gives it more moving parts to fail. Throwing hardware at something isn't a bad idea, but sometimes you can't. I worked for this insane woman in Philadelphia (Wyncote to be

Re: Speed

From: Michael Madigan mmadi10...@yahoo.com My software is too optimized, I have a gazillion index tags, which gives it more moving parts to fail. Throwing hardware at something isn't a bad idea, but sometimes you can't. Just create another software to optimize your optimizations, and bill

Re: Speed

Just create another software to optimize your optimizations, and bill it hard ! Recursive minding won't suggest that programmers equals psychotics, are they ? (i'm wondering about the correct grammar of my previous sentence : i had the choice between are they and isn't it : in this particular

Re: Speed

Le 12/09/2012 05:17, Fred Taylor a écrit : You do have an index tag on DATE in all the tables, right? Fred PUBLIC gcworkplan =SYS(3092, optimisation.txt) =SYS(3054, 12, gcworkplan) your query goes here =SYS(3054, 0) =SYS(3092, ) Run this program and open the file optimisation.txt to see what

Re: Speed

Le 12/09/2012 07:44, Fred Taylor a écrit : Internally, I don't think there's a difference, it's just syntax. oh, it's just a good habit to have ! First, if, one day, you want to upload your database towards Oracle, Sql Server, ... The Foxil ___ Post

Re: Speed

If the fact that more than one user is on the app slows the query, can you try to open the tables exclusively or to FLOCK() them just to see what happens ? Another way should be to build a COM object staying on the server and doing all the heavy queries and creating cursors or returning XML

RE: Speed

[mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: 12 September 2012 02:36 To: profox Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without

RE: Speed

Of Sytze de Boer Sent: 12 September 2012 02:36 To: profox Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring you with all the details, essentially

Re: Speed

Sytze, this sounds like it might be the oplocks problem where an application runs perfectly fine when only one user is logged in but slows down when more than one logs in. Here are my notes on switching this off. http://oplocks.net/how-to-disable-win32 Multiuser system speed 1. Set

Re: Speed

On 9/11/2012 9:35 PM, Sytze de Boer wrote: I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring you with all the details, essentially, the following code makes up

Re: Speed

On 9/11/2012 11:22 PM, Sytze de Boer wrote: Fred (Blush) NO S DOH! Dammit Sytze...you owe a round of pints for that one. :-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com

Re: Speed

What happens if you use DATE BETWEEN trcask4 and trcask5 instead of using VFP's BETWEEN function? iirc, BETWEEN(field,arg1,arg2) was NOT optimizable but field BETWEEN arg1 and arg2 was optimizable. Just tried it to prove it to myself. No difference in whichever syntax you choose,

Re: Speed

On 9/12/2012 1:02 PM, Fred Taylor wrote: What happens if you use DATE BETWEEN trcask4 and trcask5 instead of using VFP's BETWEEN function? iirc, BETWEEN(field,arg1,arg2) was NOT optimizable but field BETWEEN arg1 and arg2 was optimizable. Just tried it to prove it to myself. No

RE: Speed

, September 12, 2012 1:14 PM To: profoxt...@leafe.com Subject: Re: Speed On 9/12/2012 1:02 PM, Fred Taylor wrote: Just tried it to prove it to myself. No difference in whichever syntax you choose, optimization uses the TAG on the date field and is fully optimized. Thanks, Fred! I'm in/out

Re: Speed

...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, September 12, 2012 1:14 PM To: profoxt...@leafe.com Subject: Re: Speed On 9/12/2012 1:02 PM, Fred Taylor wrote: Just tried it to prove it to myself. No difference in whichever syntax you

Re: Speed

Programmers can fix software. Hardware... not so much. Depends on your what your job is. Fred On Wed, Sep 12, 2012 at 12:32 PM, Stephen Russell srussell...@gmail.comwrote: On Wed, Sep 12, 2012 at 12:47 PM, Fred Taylor fbtay...@gmail.com wrote: Works in VFP 7, too. -

Re: Speed

If I've been following this correctly, the speed is good when processed locally (on the same machine?) but slow most of the time when a network is involved although not always slow. I wouldn't point the finger at the server, nor the workstation...the network cables, maybe. The switch, maybe

Re: Speed

.    From: Sytze de Boer sytze.k...@gmail.com To: profox profox@leafe.com Sent: Tuesday, September 11, 2012 9:35 PM Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run

Re: Speed

Sent: Tuesday, September 11, 2012 9:35 PM Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring you with all the details, essentially, the following

Re: Speed

profox@leafe.com Sent: Tuesday, September 11, 2012 9:35 PM Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring you with all the details, essentially

Re: Speed

To: profox profox@leafe.com Sent: Tuesday, September 11, 2012 9:35 PM Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring you with all the details

RE: Speed

You might try using a statement like ...where (Date=?startdate and date=?enddate) John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: Tuesday, September 11, 2012 9:09 PM To: profox@leafe.com Subject: Re: Speed Yes

Re: Speed

On 9/11/12 6:35 PM, Sytze de Boer wrote: Can anyone suggest a way to make this go quicker? Not to go quicker, but to try to close in on the problem: Just for kicks and to try to narrow down which query (if any) is the bottleneck, split that out into 3 select statements (ditch the UNION ALL) and

Re: Speed

On Tue, Sep 11, 2012 at 6:35 PM, Sytze de Boer sytze.k...@gmail.com wrote: I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs If it's 60 sec vs 5 sec, would it be an improvement

Re: Speed

disk? editwork=c:\temp sortwork=c:\temp progwork=c:\temp tmpfiles=c:\temp From: Sytze de Boer sytze.k...@gmail.com To: profox profox@leafe.com Sent: Tuesday, September 11, 2012 9:35 PM Subject: Speed I'm losing my mind over

Re: Speed

To: profox profox@leafe.com Sent: Tuesday, September 11, 2012 9:35 PM Subject: Speed I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring

Re: Speed

That will speed it up, but it shouldn't go from 5 seconds to 30 minutes without it, should it?     From: Sytze de Boer sytze.k...@gmail.com To: profox@leafe.com Sent: Tuesday, September 11, 2012 11:22 PM Subject: Re: Speed Fred (Blush) NO S On Wed, Sep 12

Re: Speed

On a half-million record table...if the fields are pretty large and text-heavy...it might. Mike Original Message Subject: Re: Speed From: Michael Madigan mmadi10...@yahoo.com To: profoxt...@leafe.com Date: 9/11/2012 11:53 PM That will speed it up, but it shouldn't go from 5

Re: Speed

If it has to drag the entire wide table vs the just the tag segments over the wire, it could. Fred On Tue, Sep 11, 2012 at 9:53 PM, Michael Madigan mmadi10...@yahoo.comwrote: That will speed it up, but it shouldn't go from 5 seconds to 30 minutes without it, should

Re: Speed

wrote: That will speed it up, but it shouldn't go from 5 seconds to 30 minutes without it, should it? From: Sytze de Boer sytze.k...@gmail.com To: profox@leafe.com Sent: Tuesday, September 11, 2012 11:22 PM Subject: Re: Speed Fred (Blush

Re: Speed

table vs the just the tag segments over the wire, it could. Fred On Tue, Sep 11, 2012 at 9:53 PM, Michael Madigan mmadi10...@yahoo.com wrote: That will speed it up, but it shouldn't go from 5 seconds to 30 minutes without it, should

Re: Speed

Le 12/09/2012 04:36, John Harvey a écrit : You might try using a statement like ...where (Date=?startdate and date=?enddate) Going further : BETWEEN(date, start, end) is a VFP function, not a SQL clause. You should write WHERE date BETWEEN start AND end The Foxil

Re: Speed

Internally, I don't think there's a difference, it's just syntax. Fred On Tue, Sep 11, 2012 at 10:39 PM, Jean MAURICE jsm.maur...@wanadoo.frwrote: Le 12/09/2012 04:36, John Harvey a écrit : You might try using a statement like ...where (Date=?startdate and date=?enddate) Going further

[Fwd: Disable Hardware Widard ? feeling the need for SPEED.]

--- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) message/rfc822 --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this

RE: [Fwd: Disable Hardware Widard ? feeling the need for SPEED.]

Ed, Is this for real?? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of 999888 Sent: Wednesday, July 25, 2012 8:02 AM To: profoxt...@leafe.com Subject: [Fwd: Disable Hardware Widard ? feeling the need for SPEED

Re: [Fwd: Disable Hardware Widard ? feeling the need for SPEED.]

On Jul 25, 2012, at 7:24 AM, Alan Lukachko wrote: Is this for real?? Dunno. It's from an actual subscriber, which is why it made it through, but it sure looks like a spam attempt. Now you know why I strip attachments. :) -- Ed Leafe ___

Corruption, Locking Issues and Speed

to live on a Windows Server 2000 box and the clients were Windows XP there was no problems. Since then the application now suffers from poorer speed (despite the better hardware!) and constant locking issues. Is this SMB2? Is this OpLocks? Is this a Server Problem? Is this a Client Problem

Re: Corruption, Locking Issues and Speed

15 regular users of this VFP application and when it used to live on a Windows Server 2000 box and the clients were Windows XP there was no problems. Since then the application now suffers from poorer speed (despite the better hardware!) and constant locking issues. Is this SMB2

RE: Corruption, Locking Issues and Speed

...@leafe.com Subject: Re: Corruption, Locking Issues and Speed On 4/19/2012 10:18 AM, Chris Davis wrote: Hi All I can see this question has already been asked in some shape or form or is currently being asked but I have now read that many explanations I am not sure what applies. So forgive me

Re: Corruption, Locking Issues and Speed

On 4/19/2012 10:37 AM, Chris Davis wrote: Thanks Mike I will double check this now although I have been assured this is already the case. Thanks Chris. Years ago I had a problem with Avast not respecting my exclusions. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief

RE: Corruption, Locking Issues and Speed

Subject: Re: Corruption, Locking Issues and Speed On 4/19/2012 10:37 AM, Chris Davis wrote: Thanks Mike I will double check this now although I have been assured this is already the case. Thanks Chris. Years ago I had a problem with Avast not respecting my exclusions. -- Mike Babcock

Re: Corruption, Locking Issues and Speed

Has to exclude the programs too. From: Chris Davis chr...@actongate.co.uk To: profox@leafe.com profox@leafe.com Sent: Thursday, April 19, 2012 10:52 AM Subject: RE: Corruption, Locking Issues and Speed The Anti Virus on this site is ... Trend Micro OfficeScan

Re: Corruption, Locking Issues and Speed

I think the speed hit you took was because op locks is shut off.   Better that than corruption.  From: Chris Davis chr...@actongate.co.uk To: profox@leafe.com profox@leafe.com Sent: Thursday, April 19, 2012 10:52 AM Subject: RE: Corruption, Locking Issues

Select speed

Hello foxers Probably a dumb question but I'll risk it If I have a large history file indexed on a number (9) fields e.g. CLIENT, STOCKCODE etc If I issue command SELECT FLD1, FLD2, FLD3, FROM MYTABLE etc, does it matter which ORDER is set if I want a range of clients, or a range of stock codes.

Re: Select speed

no, SELECT - SQL is not affected by the current order of the table, only by what indexes are available and if they match your filtering/joining clauses Frank. Frank Cazabon On 21/11/2011 04:14 PM, Sytze de Boer wrote: Hello foxers Probably a dumb question but I'll risk it If I have a

Re: Select speed

On Mon, Nov 21, 2011 at 2:14 PM, Sytze de Boer sytze.k...@gmail.com wrote: Hello foxers Probably a dumb question but I'll risk it If I have a large history file indexed on a number (9) fields e.g. CLIENT, STOCKCODE etc If I issue command SELECT FLD1, FLD2, FLD3, FROM MYTABLE etc, does it

RE: Speed and complexity of report

I haven't used it myself yet but try looking at the Task Pane Manager Solution Samples. The What's New in VFP 9 section has a couple examples on how to use multi-detail band reports. -- rk -Original Message- Subject: Speed and complexity of report Questions Is this a multiple detail

Speed and complexity of report

be the history table Questions Is this a multiple detail band report... I've never used them before. If so, how would I do it? (Hints please) Also, the simple report of the first query takes a long time to display... How Can I speed it up? TIA, Mike

Re: Speed and complexity of report

On 10/04/11 15:37, Michael Savage wrote: Also, the simple report of the first query takes a long time to display... How Can I speed it up? Mike By 'the first query' do you mean just the invoice and its detail? Or do you mean a query producing the entire hierarchy you showed? What

Re: [NF] How we found the speed of light: it's not infinite! (300 years ago)

Jarvis, Matthew wrote: For the astonomy geeks out there (including myself)... http://scienceblogs.com/startswithabang/2011/09/how_we_found_the_speed_o f_ligh.php Hi Matthew, I like the Galileo conclusion: very, very fast. -- Regards, Pete http://pete-theisen.com/

[NF] How we found the speed of light: it's not infinite! (300 years ago)

For the astonomy geeks out there (including myself)... http://scienceblogs.com/startswithabang/2011/09/how_we_found_the_speed_o f_ligh.php Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 ||

Re: Windows 7 + VFP9 speed problem

Thanks for the jump...late or not! I'll check these out when I put some new systems together next week and let you know the results. Appreciate the input. Mike Not sure about the GDIPLUS.DLL, but I'm using XFRX to write PDF files for reports, and I think it likes having GDIPLUS.DLL around.

RE: Windows 7 + VFP9 speed problem

] On Behalf Of Mike Copeland Sent: Thursday, March 10, 2011 2:10 PM To: profoxt...@leafe.com Subject: Re: Windows 7 + VFP9 speed problem Thanks for the jump...late or not! I'll check these out when I put some new systems together next week and let you know the results. Appreciate the input

RE: Windows 7 + VFP9 speed problem

Not sure about the GDIPLUS.DLL, but I'm using XFRX to write PDF files for reports, and I think it likes having GDIPLUS.DLL around. Sorry for jumping in late in the game (off the hook busy), but the GDIPlus.DLL is required for the VFP runtimes. Some of the most queried entries on the Visual

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

On Sun, 06 Mar 2011 12:43 -0600, Mike Copeland mlcopel...@gmail.com wrote: The process also rebooted twice...good old Windows...just to let me know it was authentic. LOL yeah, that probably serves no other purpose than making you think it's doing something. -- Alan Bourke alanpbourke

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

On Sat, 05 Mar 2011 17:18 -0600, Mike Copeland mlcopel...@gmail.com wrote: PROBLEM SOLVED I think it's pretty obvious: There is a system function call being used by the DBI ctGrid (both version 3 and 4) OCX file when it is accepting data input for the grid combo that Win7 Home Premium

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

I figured the same...I thought that the code for everything 7 had already been installed with the Home package and given a Home, or Pro, or Ultimate authorization code, Win7 would act accordingly...turning on and off features. Not so. After putting in the $77 code, it took about 10 to 15

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

On 3/6/2011 1:43 PM, Mike Copeland wrote: I figured the same...I thought that the code for everything 7 had already been installed with the Home package and given a Home, or Pro, or Ultimate authorization code, Win7 would act accordingly...turning on and off features. Not so. After putting

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

Ahhhso you did! I tried setting the values (the third parameter) to different values and nothing seemed to act different, and none of the sys() values that I checked changed. I'm not saying it's not useful but I've not used it for quite a while, so until it's broke... Mike On 3/6/2011

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

PROBLEM SOLVED I used Windows Anytime Upgrade to upgrade the Win7 Home Premium 32-bit system to Win7 PRO 32-bit, un-registered the OCX control, re-registered it, ran my EXE locally, and loaded all 23,000 SKUs in under 1/2 second. I think it's pretty obvious: There is a system function call

Re: Windows 7 + VFP9 speed problem ---PROBLEM SOLVED

On 3/5/2011 6:18 PM, Mike Copeland wrote: PROBLEM SOLVED I used Windows Anytime Upgrade to upgrade the Win7 Home Premium 32-bit system to Win7 PRO 32-bit, un-registered the OCX control, re-registered it, ran my EXE locally, and loaded all 23,000 SKUs in under 1/2 second. I think it's pretty

RE: Windows 7 + VFP9 speed problem

, March 04, 2011 1:47 AM To: profoxt...@leafe.com Subject: Re: Windows 7 + VFP9 speed problem Thanks Fred! Yes, _vfp.autoyield is set to .F. in the form's Load event. I'm not aware of any place to set this other than in the code that is executed both during runtime and IDE. Along those same lines

Re: Windows 7 + VFP9 speed problem

On 3/3/2011 7:56 PM, Mike Copeland wrote: PS. I'm still hoping that MSoft will need cash someday and will sell the Fox rights and source code to someone who will resurrect it. Of course, then it would kick VB and Access's rear... There won't be a VB then! Probably not Access either. But

Re: Windows 7 + VFP9 speed problem

On 3/3/2011 10:42 PM, Mike Copeland wrote: The three VFP files that are needed, to my knowledge, are GDIPLUS.DLL VFP9R.DLL VFP9RENU.DLL Not sure about the GDIPLUS.DLL, but I'm using XFRX to write PDF files for reports, and I think it likes having GDIPLUS.DLL around. I did

Res: Windows 7 + VFP9 speed problem

Mike Have u tried to delay the loading of the grid ? Something like a button that the user has to press in order to fill the grid. E. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: Res: Windows 7 + VFP9 speed problem

Eurico, Yes. I tried both with a button and a timer. Both acted the same way...slow in the slow scenario, fast in the fast scenario. Mike Mike Have u tried to delay the loading of the grid ? Something like a button that the user has to press in order to fill the grid. E.

Re: Windows 7 + VFP9 speed problem

Maybe, but the way Steve-o is running things, M$ofts future might not be so guaranteed. Mike On 3/3/2011 7:56 PM, Mike Copeland wrote: PS. I'm still hoping that MSoft will need cash someday and will sell the Fox rights and source code to someone who will resurrect it. Of course, then it

Windows 7 + VFP9 speed problem

, no change) Also, you'll notice there's no indication of how I'm getting the data from MySQL. The sample below has the same speed issues described above, but as you can see the retrieval from the MySQL server is not involved in the timing and is actually very fast in all scenarios

RE: Windows 7 + VFP9 speed problem

Sent: Wednesday, March 02, 2011 3:03 PM To: profoxt...@leafe.com Subject: Windows 7 + VFP9 speed problem It's been a while since I've been on the list, but I've run into a real buzz-saw of a VFP problem, thanks in part to Windows 7. I'd really be appreciative of any and all thoughts on this issue

RE: Windows 7 + VFP9 speed problem

...@leafe.com] On Behalf Of Mike Copeland Sent: Wednesday, March 02, 2011 3:03 PM To: profoxt...@leafe.com Subject: Windows 7 + VFP9 speed problem It's been a while since I've been on the list, but I've run into a real buzz-saw of a VFP problem, thanks in part to Windows 7. I'd really be appreciative of any

Re: Windows 7 + VFP9 speed problem

On 3/2/2011 3:02 PM, Mike Copeland wrote: snipped MESSAGEBOX('Starting to load Grid. Click OK to start...',0+64,'Notice') LOCAL ttimestart,ttimeexp SELECT sku FROM skus into temp WHERE active=1 order by sku SELECT temp GO TOP IN temp ttimestart=seconds() SCAN WHILE !EOF('temp')

RE: Windows 7 + VFP9 speed problem

below has the same speed issues described above, but as you can see the retrieval from the MySQL server is not involved in the timing and is actually very fast in all scenarios. -- MESSAGEBOX('Starting to load Grid. Click OK to start

Re: Windows 7 + VFP9 speed problem

win7 computer with 4gb. It must be something to do with the operating system and memory management or hardware. - Original Message - From: Mike Copeland mlcopel...@gmail.com To: profoxt...@leafe.com Sent: Wednesday, March 02, 2011 12:02 PM Subject: Windows 7 + VFP9 speed problem It's

Re: Windows 7 + VFP9 speed problem

Mike I deal with a large VFP9 application that is installed on thousands of sites, and we are seeing occurrences of this also, to the extent where a customer will bring in a new Windows 7 machine and it will be extremely slow, with the other 5-year-old XP machines on the network being fast at the

Re: Windows 7 + VFP9 speed problem

On Thu, Mar 3, 2011 at 3:29 PM, Alan Bourke alanpbou...@fastmail.fm wrote: If you have a Windows Server 2008 in the mix you definitely need to either set the server to use SMB1 over SMB2, or alternatively apply the SMB2 hotfix that MS released recently. This will stop index corruption issues

RE: Windows 7 + VFP9 speed problem

kamcgin...@gmail.com wrote on 2011-03-03: I don't have experience with MySQL so I probably would point to that as a likely problem. Like most developers we have many clients converting to Win7 with no problems at all unlike the nightmare we had with Crapsta. We have noticed one thing that

Re: Windows 7 + VFP9 speed problem

On 3/3/2011 10:55 AM, Tracy Pearson wrote: I wonder if this much memory ends up swapping. This might be a good reason to change the SYS(3050) settings. Perhaps your Config.fpw might need the old MEMLIMIT, which may not work in VFP 9 at all Use Ed Leafe's Setmemory.prg. It's in the Downloads

RE: Windows 7 + VFP9 speed problem

Many years ago we had a FPW2.6 app which ran faster with 32Mb of RAM than it did with 64Mb of RAM. We put this down to memory swapping - could this be the cause here? John Weller 01380 723235 07976 393631 We have noticed one thing that may be of interest: We have a client with a new Win7

Re: Windows 7 + VFP9 speed problem

Mike: I agree with Michael Babcock's suggestions - use a cursor and use LOCATE instead of GO TOP. But that doesn't seem to explain the difference in your four scenarios. IIRC, the one that fails is the compiled app on a local VFP 7. Which leads to a few questions: a) Is this one system only

Re: Windows 7 + VFP9 speed problem

Of Mike Copeland Sent: Wednesday, March 02, 2011 3:03 PM To: profoxt...@leafe.com Subject: Windows 7 + VFP9 speed problem It's been a while since I've been on the list, but I've run into a real buzz-saw of a VFP problem, thanks in part to Windows 7. I'd really be appreciative of any and all

Re: Windows 7 + VFP9 speed problem

-Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Wednesday, March 02, 2011 3:03 PM To: profoxt...@leafe.com Subject: Windows 7 + VFP9 speed problem It's been a while since I've been on the list, but I've run

Re: Windows 7 + VFP9 speed problem

gurus out there? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Wednesday, March 02, 2011 3:03 PM To: profoxt...@leafe.com Subject: Windows 7 + VFP9 speed problem It's been a while

Re: Windows 7 + VFP9 speed problem

Thanks Mike! I'll try that. Hell, I'll try anything. The WHILE !EOF('temp') is an old habit that makes it easier for me to read the code and grasp what is going on. As for the 23,000 items...I'm in an odd situation with a client that involves both technical-computer issues and my competency,

Re: Windows 7 + VFP9 speed problem

Alan, MANY thanks for your time to send the info below!!! One puzzlerwhy is the same routine slow when the code only has to load from a 23,000 record DBF file that is local (in the same folder as the EXE)? I tried by commenting out all the code that fetched the data from the server,

Re: Windows 7 + VFP9 speed problem

Tracy, Many thanks! Yes, I tried the Firstdraw event as that is a pretty common issue with DBI components. And, I was surprised that it made no difference at all. I also tried a few other form events and ctGrid events...I forget which ones now because it was in the wee hours a few days ago.

Re: Windows 7 + VFP9 speed problem

Hi Mike, loading 23,000 SKUs isn't the problem, but loading them in a combo box/drop down list is what the others' comments were about. I believe the interface guidelines are that a combo is for a relatively few choices (less than 100 or 200 is the maximum I've heard mentioned). You can use

RE: Windows 7 + VFP9 speed problem

if the speed is due to the eye candy. Explain the full structure of the form this is on. Is the ctGrid object on a page in a pageframe, in a container, are other ActiveX controls on the form, is there other code associated in events of the ctGrid that might be redrawing the control as it is getting

Re: Windows 7 + VFP9 speed problem

...@leafe.com Subject: Windows 7 + VFP9 speed problem It's been a while since I've been on the list, but I've run into a real buzz-saw of a VFP problem, thanks in part to Windows 7. I'd really be appreciative of any and all thoughts on this issue as I'm stumped. Application: A monolithic accounting

Re: Windows 7 + VFP9 speed problem

ran, I could get Windows+VFP to put it where I wanted it to but it didn't make any difference in speed. I also noticed that by looking in the temp folder while the program was paused messagebox('File location: '+dbf('temp'),0,'Notice') that Windows never created any file

Re: Windows 7 + VFP9 speed problem

John, It certainly makes more sense than anything else. I used the SetMem routine (from the Profox board) in all my apps for the last few years, and for some reason I commented it out at some point. I'll reactivate it and try... Nope. Identical results. But, that does validate that VFP isn't

Re: Windows 7 + VFP9 speed problem

Frank, I'm in total agreement, but the way that DBI's ctGrid loads its combo is a little different. Essentially, you load all the possible data into the ctGrid memory manager, and then the drop down acts like an incremental search. My clients love it. Once the data is loaded into ctGrid, it's

Re: Windows 7 + VFP9 speed problem

(I asked if write caching was turned off.) On 3/3/2011 12:17 PM, Mike Copeland wrote: c) You got me here. Tell me how to do that and I'll try it! But it seems odd that running the EXE from a network drive is fast. I mean, I THINK that the local drive is used for cursors and caching and such

Re: Windows 7 + VFP9 speed problem

John, What happens if you disconnect your PC from the internet and then temporarily turnoff your workstations virus/security software? Does that make a difference? Malcolm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Windows 7 + VFP9 speed problem

form, which also loads the same 23,000 SKUs in the INIT event of the form. Same speed...78 to 80 seconds. Important to note that my timing only involves the combo load...not the data manipulation or retrieval. Observation: I think it's relevant that I do see SLOWER speeds when attempting the same

Re: Windows 7 + VFP9 speed problem

Malcolm, Good thoughtI run AVAST Anti virus and I had already tried disabling it. No change. Also, this box has never had any third party firewalls, like Zonealarm, that love to get their fingers into everyone's pie. Most of my testing has been done on a brand new box with Win7 Home 32bit

Re: Windows 7 + VFP9 speed problem

On 3/3/2011 2:09 PM, Mike Copeland wrote: Thanks Mike! I'll try that. Hell, I'll try anything. The WHILE !EOF('temp') is an old habit that makes it easier for me to read the code and grasp what is going on. As for the 23,000 items...I'm in an odd situation with a client that involves both

  1   2   3   4   >