Is record processing with a database opened with "Use database exclusive"
different if you SET EXCLUSIVE ON too?
- Original Message -
From: "MB Software Solutions, LLC"
To: ProFox Email List
Cc:
Sent: Friday, March 16, 2012 5:32 PM
Subject: Re: SET EXCLUSIVE
On 3/16/2012 5:16 PM, Sytze de Boer wrote:
> In most of my apps, I have a routine to reindex all data, pack all data etc
> (Exlusive use is required to do this)
>
> I've just tested this and by setting exclusive off
> It makes a huge difference !!
Again, these are READ-ONLY (query) operations I'm
In most of my apps, I have a routine to reindex all data, pack all data etc
(Exlusive use is required to do this)
I've just tested this and by setting exclusive off
It makes a huge difference !!
S
On Sat, Mar 17, 2012 at 10:11 AM, MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwares
On 3/16/2012 4:45 PM, Paul Hill wrote:
> On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis wrote:
>> On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC
>> wrote:
>>> If you're running something local (not on the network but your own local
>>> drive), does using SET EXCLUSIVE ON improve the perf
riday, March 16, 2012 4:46 PM
To: profoxt...@leafe.com
Subject: Re: SET EXCLUSIVE -- faster processing?
On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis wrote:
> On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC
> wrote:
>> If you're running something local (not on th
On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis wrote:
> On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC
> wrote:
>> If you're running something local (not on the network but your own local
>> drive), does using SET EXCLUSIVE ON improve the performance enough (if
>> at all) to notice? I th
On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC
wrote:
> If you're running something local (not on the network but your own local
> drive), does using SET EXCLUSIVE ON improve the performance enough (if
> at all) to notice? I thought I had heard that rumor years ago.
>
> tia,
> --Mike
If you're running something local (not on the network but your own local
drive), does using SET EXCLUSIVE ON improve the performance enough (if
at all) to notice? I thought I had heard that rumor years ago.
tia,
--Mike
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software
8 matches
Mail list logo