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 data
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
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
You need to be sure as this is a big problem for data.all pc's need to be
checked.
Al
Sent from Samsung Mobile
Michael Madigan wrote:
As far as I can tell, caching is turned off for all users and server.
From: Mike Copeland
To: profox@leafe.com
Sent: Tuesd
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 wrote:
> 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(dat
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
___
What does SYS(3054) tell you about the optimization?
Fred
On Tue, Sep 11, 2012 at 10:29 PM, Sytze de Boer wrote:
> Thanks to your *hint* Fred, I can state it DOES
>
>
> On Wed, Sep 12, 2012 at 5:27 PM, Fred Taylor wrote:
>
> > If it has to drag the entire wide table vs the just the tag segment
Thanks to your *hint* Fred, I can state it DOES
On Wed, Sep 12, 2012 at 5:27 PM, Fred Taylor wrote:
> 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 >wrote:
>
> > That will speed it
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 wrote:
> That will speed it up, but it shouldn't go from 5 seconds to 30 minutes
> without it, should it?
>
>
>
>
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
To: profoxt...@leafe.com
Date: 9/11/2012 11:53 PM
That will speed it up, but it shouldn't go from 5 seconds to 30 minutes
That will speed it up, but it shouldn't go from 5 seconds to 30 minutes without
it, should it?
From: Sytze de Boer
To: profox@leafe.com
Sent: Tuesday, September 11, 2012 11:22 PM
Subject: Re: Speed
Fred
(Blush) NO
S
On Wed, Sep 12, 2012 at 3:17 PM, Fred
Fred
(Blush) NO
S
On Wed, Sep 12, 2012 at 3:17 PM, Fred Taylor wrote:
> You do have an index tag on DATE in all the tables, right?
>
> Fred
>
>
> On Tue, Sep 11, 2012 at 7:08 PM, Sytze de Boer
> wrote:
>
> > Yes, config.fpw points to c:\temp
> > They didn't to begin with (c:\) but I changed t
You do have an index tag on DATE in all the tables, right?
Fred
On Tue, Sep 11, 2012 at 7:08 PM, Sytze de Boer wrote:
> Yes, config.fpw points to c:\temp
> They didn't to begin with (c:\) but I changed that
>
> I installed a basic little server at my office (Win 2003)
> I copied their data to
On Tue, Sep 11, 2012 at 6: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
If it's 60 sec vs 5 sec, would it be an improvement to copy the tab
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
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
Yes, config.fpw points to c:\temp
They didn't to begin with (c:\) but I changed that
I installed a basic little server at my office (Win 2003)
I copied their data to it
Running with 100 Mbit cable and swith, I get 30 secs and 5 secs on
subsequent runs
Running Gigabit cable and switch, I get 7 sec
Since it only takes 5 seconds locally, it can't be a index issue or an
optimization issue.
Are the temp files set to local client disk?
editwork=c:\temp
sortwork=c:\temp
progwork=c:\temp
tmpfiles=c:\temp
From: Sytze de Boer
To: profox
Sent: Tuesday, Sept
Thanks for that, but we have discounted that by removing the AV software,
on the server as well as workstation
S
On Wed, Sep 12, 2012 at 1:53 PM, Michael Madigan wrote:
> Sounds like it could be an antivirus program problem. Shut off antivirus
> on the client and see what happens. If that
Sounds like it could be an antivirus program problem. Shut off antivirus on
the client and see what happens. If that fixes the problem then you have to
have your antivirus program ignore the network data directory.
If it runs well locally, it should run fairly well over the network.
Check the network. In my case it was bad cabling.
E.
>
> From: Michael Madigan
>To: ProFox Email List
>Sent: Tuesday, September 11, 2012 6:14 PM
>Subject: Re: error 114 - index does not match table, recreate index
>
>As far as I can tell, caching is turned of
As far as I can tell, caching is turned off for all users and server.
From: Mike Copeland
To: profox@leafe.com
Sent: Tuesday, September 11, 2012 5:12 PM
Subject: Re: error 114 - index does not match table, recreate index
Caching? Server?
Original Me
Caching? Server?
Original Message
Subject: Re: error 114 - index does not match table, recreate index
From: Michael Madigan
To: profoxt...@leafe.com
Date: 9/11/2012 3:40 PM
I have an overnight job that rebuilds it every night.
This is intermittent. I would think that once it'
I have an overnight job that rebuilds it every night.
This is intermittent. I would think that once it's corrupted, this error would
occur all the time afterwards, but it doesn't. It occurs a few times a day
then it seems to "heal" itself. Makes no sense to me.
I don't know about 2.6 but I think you can recreate the error.
I encounter it when
1 I have tables and cdx's as from (say) to day
2 I now restore the dbf's only from (say) a month ago
What I do in such a situation is to delete the cdx files and re-create the
indexes
On Wed, Sep 12, 2012 at 7:3
On a 2.6 system, I can't duplicate this when I open the table, set the order to
every tag and browse.
I've seen where this might be an error with anti-virus software confusing the
system, although I think I have the antivirus ignoring the data directory.
Anybody else see this, which appears
I think she crashed right off the bat in her last race... not injured but no
place. I liked it when I used to log-in and she would smile.
Gary Jeurink
-Original Message-
From: Mike Copeland [mailto:m...@ggisoft.com]
Sent: Monday, September 10, 2012 4:19 PM
To: profox@leafe.com
Subject: Re
Sytze - if my memory serves me correctly - I believe that Gary Jeurink
on this list had worked on something like that a while ago. Of course, I
could be wrong...
Although - I see he has not replied to this thread yet. Maybe he hasn't
check the ProFox list e-mails in a little while...
Just curious
Perhaps after reading this people here will stop trying to convince
those whose opinions differ, since it ain't gonna happen.
http://www.motherjones.com/politics/2011/03/denial-science-chris-mooney
( -or- http://j.mp/UHAID6 )
Of course, those on one end of the spectrum will rejec
I don't have such software; I was just clarifying your need.
Good luck!
--Mike
On 9/10/2012 3:11 PM, Sytze de Boer wrote:
> Yes
> With facility to edit
>
> S
>
>
> On Tue, Sep 11, 2012 at 3:06 AM, MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
>> On 9/10/201
30 matches
Mail list logo