Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #5638 > unrolled thread

SetFilter cancels the default rdd

Started byKrystian <softb@softb.pl>
First post2013-08-05 05:52 -0700
Last post2013-08-10 05:26 -0700
Articles 8 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  SetFilter cancels the default rdd Krystian <softb@softb.pl> - 2013-08-05 05:52 -0700
    Re: SetFilter cancels the default rdd "Wolfgang Riedmann" <wriedmann@gmail.com> - 2013-08-05 17:04 +0200
      Re: SetFilter cancels the default rdd Krystian <softb@softb.pl> - 2013-08-05 09:12 -0700
    Re: SetFilter cancels the default rdd "Wolfgang Riedmann" <wriedmann@gmail.com> - 2013-08-05 17:09 +0200
      Re: SetFilter cancels the default rdd Krystian <softb@softb.pl> - 2013-08-05 09:28 -0700
        Re: SetFilter cancels the default rdd "Wolfgang Riedmann" <wriedmann@gmail.com> - 2013-08-05 20:55 +0200
          Re: SetFilter cancels the default rdd D.J.W. van Kooten <public@ic2remove.this.com> - 2013-08-07 23:04 +0200
    Re: SetFilter cancels the default rdd Krystian <softb@softb.pl> - 2013-08-10 05:26 -0700

#5638 — SetFilter cancels the default rdd

FromKrystian <softb@softb.pl>
Date2013-08-05 05:52 -0700
SubjectSetFilter cancels the default rdd
Message-ID<0018e291-a145-40e5-91fe-258609fc9d07@googlegroups.com>
Hello,

1.
I try to describe the problem :

in initialize module I set
RddSetDefault("DBFNTX")

In one of a module of a program
 I check the rdd -> OK
akt_ext := ORDBAGEXT()  -> NTX

I open one of a database with CDX mode with "my" function "przydziel";
an index file in a cdx standard is created and the default rdd is set to ntx
 
SELF:rcp_dane := przydziel(xkat_dane+'rcp_dane')
akt_ext := ORDBAGEXT() -> NTX

txt defines a filtration formula loosely connected with one of the index key;
I create 7 indexes for this database
SELF:rcp_dane:SetFilter(txt)
akt_ext := ORDBAGEXT -> CDX  ???

Is it such situation normal ?
(It took me time, to find where was problem; I did not expect problem with this instruction).
Is it possible to turn off the connection between filter on rdd or I must to change the logic of my app ? (I open databases of my old apps written in clipper with ntx and new databases written in cavo with cdx).

2.
I have a problem with speed of this application - bbrowser works very slow.
When work 1 or 2 persons - it is OK; but when start to work 20 simultaneously - the performance dramatically falls down.
First - I thought about changing the rdd : from ntx to cdx.
Second - if it does not help, to move the main database to sql; it will work in mixed environment because old files are still in dbf.

What do you think about this solutions ?

Thank you in advance
With regards
Krystian Besler

[toc] | [next] | [standalone]


#5640

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2013-08-05 17:04 +0200
Message-ID<b69t7kFffbqU1@mid.individual.net>
In reply to#5638
Hi Krystian,

the OrdBagExt() function is like most DB... and Ord... dependent on the
current workarea.

If you call this function when the currently active workarea is opened
by the DBFNTX RDD, "NTX" will be returned.

If you set the currently active workarea to another where the table is
opened with the DBFCDX RDD, "CDX" will be returned.

This is by design, and so since Clipper time. The DBServer classes are
hiding these details only, but are based on them.

If you need the function based approach, you need to select forst the
correct workarea, or prefix the call with the workarea number or the
alias:
( nArea )->OrdbagExt()
rcp_dane->OrdBagExt()

HTH


Wolfgang




-- 

[toc] | [prev] | [next] | [standalone]


#5644

FromKrystian <softb@softb.pl>
Date2013-08-05 09:12 -0700
Message-ID<d20f9d5e-a30a-4d9a-9aa7-73cc07b6adb4@googlegroups.com>
In reply to#5640
W dniu poniedziałek, 5 sierpnia 2013 17:04:20 UTC+2 użytkownik Wolfgang Riedmann napisał:
> Hi Krystian,
> 
> 
> 
> the OrdBagExt() function is like most DB... and Ord... dependent on the
> 
> current workarea.
> 
> 
> 
> If you call this function when the currently active workarea is opened
> 
> by the DBFNTX RDD, "NTX" will be returned.
> 
> 
> 
> If you set the currently active workarea to another where the table is
> 
> opened with the DBFCDX RDD, "CDX" will be returned.
> 
> 
> 
> This is by design, and so since Clipper time. The DBServer classes are
> 
> hiding these details only, but are based on them.
> 
> 
> 
> If you need the function based approach, you need to select forst the
> 
> correct workarea, or prefix the call with the workarea number or the
> 
> alias:
> 
> ( nArea )->OrdbagExt()
> 
> rcp_dane->OrdBagExt()
> 
> 
> 
> HTH
> Wolfgang
 
> --

Hello Wolfgang,

Thank you for your precise answer; I do not realize, that even, if I use only methods of a dbserver class, all the relationships with work areas play important roles. I must to rewrite my open function. In the meantime I changed the default rdd to cdx, but I must be aware the role of current work areas.

Thank you very much
With regards 
Krystian Besler

[toc] | [prev] | [next] | [standalone]


#5641

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2013-08-05 17:09 +0200
Message-ID<b69tgrFfhirU1@mid.individual.net>
In reply to#5638
Hi Christian,

> 2.
> I have a problem with speed of this application - bbrowser works very
> slow.  When work 1 or 2 persons - it is OK; but when start to work 20
> simultaneously - the performance dramatically falls down.  First - I
> thought about changing the rdd : from ntx to cdx.  Second - if it
> does not help, to move the main database to sql; it will work in
> mixed environment because old files are still in dbf.

having 20 concurrent users on the same DBF will slow down, that is too
much for DBF access.

You have 2 possibilities: use ADS. This will cost some money, but you
an maintain your application structure, or change to SQL. Probably this
will cause a complete redesign of your app, because the approach for a
positional database like DBFs and a relational database like SQL is too
different.

Wolfgang

P.S. I'm using both DBFCDX and ADS in some projects, and MySQL and
Oracle in other projects, so I'm speaking of own experience


-- 

[toc] | [prev] | [next] | [standalone]


#5645

FromKrystian <softb@softb.pl>
Date2013-08-05 09:28 -0700
Message-ID<1ae32ad4-44e8-4c02-bf2f-b3edab90a5cd@googlegroups.com>
In reply to#5641
W dniu poniedziałek, 5 sierpnia 2013 17:09:14 UTC+2 użytkownik Wolfgang Riedmann napisał:
> Hi Christian,
> 
> 
> 
> > 2.
> 
> > I have a problem with speed of this application - bbrowser works very
> 
> > slow.  When work 1 or 2 persons - it is OK; but when start to work 20
> 
> > simultaneously - the performance dramatically falls down.  First - I
> 
> > thought about changing the rdd : from ntx to cdx.  Second - if it
> 
> > does not help, to move the main database to sql; it will work in
> 
> > mixed environment because old files are still in dbf.
> 
> 
> 
> having 20 concurrent users on the same DBF will slow down, that is too
> 
> much for DBF access.
> 
> 
> 
> You have 2 possibilities: use ADS. This will cost some money, but you
> 
> an maintain your application structure, or change to SQL. Probably this
> 
> will cause a complete redesign of your app, because the approach for a
> 
> positional database like DBFs and a relational database like SQL is too
> 
> different.
> 
> 
> 
> Wolfgang
> 
> 
> 
> P.S. I'm using both DBFCDX and ADS in some projects, and MySQL and
> 
> Oracle in other projects, so I'm speaking of own experience
> 
> 
> 
> 
> 
> --

Hi Wolfgang,

Thank you for "enlightenment" me - up to now I worked with medium dbf's (< 100000) and max 4,5 persons from one department. Now I must prepare a program for many people from many departments, cooperating with my old one. I think, that I should to become familiar with sql - I do not escape from that architecture.
I do not know the shortcut of ADS - what is this ?

Thank you for your help and time
With regards
Krystian Besler

PS
I you know any examples of connecting bbrowser with sql, I will be very grateful.

[toc] | [prev] | [next] | [standalone]


#5650

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2013-08-05 20:55 +0200
Message-ID<b6aap0Fif5dU1@mid.individual.net>
In reply to#5645
Hi Krystian,

> Thank you for "enlightenment" me - up to now I worked with medium
> dbf's (< 100000) and max 4,5 persons from one department. Now I must
> prepare a program for many people from many departments, cooperating
> with my old one. I think, that I should to become familiar with sql -
> I do not escape from that architecture.  I do not know the shortcut
> of ADS - what is this ?


ADS is Advantage Database Server - a commercial database server that is
available as VO, Vulcan and Clipper RDD.
There are some changes in filters and some other minor issues to
change, but for the normal operation if works like DBFCDX, only faster
and without data corruption.
One of my large clients has a 45 user installation running - with
normally 30-40 people accessing the database at the same time.

ADS is not cheap, but cheaper than rewrite the applications.

I don't use bBrowser with SQL - for SQL access I use only ListViews
because the data volume is fixed and will not change when the
underlying data changes. It is not so dynamic as DBF.

Wolfgang

-- 

[toc] | [prev] | [next] | [standalone]


#5656

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-08-07 23:04 +0200
Message-ID<m7d509d7o85a8v166cviprpkfj34u076ni@4ax.com>
In reply to#5650
On Mon, 5 Aug 2013 20:55:28 +0200, "Wolfgang Riedmann"
<wriedmann@gmail.com> wrote:

Hello Krystian,

>There are some changes in filters and some other minor issues to
>change, but for the normal operation if works like DBFCDX, only faster
>and without data corruption.
>One of my large clients has a 45 user installation running - with
>normally 30-40 people accessing the database at the same time.
>
>ADS is not cheap, but cheaper than rewrite the applications.
>

I encountered more problems with ADS than I expected, especially
version 11. If you combine opening ADS with DBFCDX you are likely to
encounter more data corruption than you ever had with DBFCDX alone.
Apart from rewriting filters and few more things, you must make sure
that there is no way DBFCDX can still open databases, by checking
"Non-Exclusive Proprietary Locking" and AX_AXSLocking(true) which
makes access to your DBF files outside ADS only read only. 

Hence make sure that you adapt your program completely to accomodate
this.

Dick

[toc] | [prev] | [next] | [standalone]


#5668

FromKrystian <softb@softb.pl>
Date2013-08-10 05:26 -0700
Message-ID<0d3cd4f8-4797-49c6-ab01-662a302b149b@googlegroups.com>
In reply to#5638
W dniu poniedziałek, 5 sierpnia 2013 14:52:48 UTC+2 użytkownik Krystian napisał:
> Hello,
> 
> 
> 
> 1.
> 
> I try to describe the problem :
> 
> 
> 
> in initialize module I set
> 
> RddSetDefault("DBFNTX")
> 
> 
> 
> In one of a module of a program
> 
>  I check the rdd -> OK
> 
> akt_ext := ORDBAGEXT()  -> NTX
> 
> 
> 
> I open one of a database with CDX mode with "my" function "przydziel";
> 
> an index file in a cdx standard is created and the default rdd is set to ntx
> 
>  
> 
> SELF:rcp_dane := przydziel(xkat_dane+'rcp_dane')
> 
> akt_ext := ORDBAGEXT() -> NTX
> 
> 
> 
> txt defines a filtration formula loosely connected with one of the index key;
> 
> I create 7 indexes for this database
> 
> SELF:rcp_dane:SetFilter(txt)
> 
> akt_ext := ORDBAGEXT -> CDX  ???
> 
> 
> 
> Is it such situation normal ?
> 
> (It took me time, to find where was problem; I did not expect problem with this instruction).
> 
> Is it possible to turn off the connection between filter on rdd or I must to change the logic of my app ? (I open databases of my old apps written in clipper with ntx and new databases written in cavo with cdx).
> 
> 
> 
> 2.
> 
> I have a problem with speed of this application - bbrowser works very slow.
> 
> When work 1 or 2 persons - it is OK; but when start to work 20 simultaneously - the performance dramatically falls down.
> 
> First - I thought about changing the rdd : from ntx to cdx.
> 
> Second - if it does not help, to move the main database to sql; it will work in mixed environment because old files are still in dbf.
> 
> 
> 
> What do you think about this solutions ?
> 
> 
> 
> Thank you in advance
> 
> With regards
> 
> Krystian Besler

Hello Dick,

Thank you for warnings about ADS, but I do not intend to use this tool. For me it is like a prosthesis; dbf's are not dedicated to operate with many users. I think, that it is better for me to learn sql principles because it is natural in such situation - and what is also important, many sql engines are free for end users and the classes are built into the cavo. 
I did not answer for so long, because I rewrite part of my new app to operate with sql and I still learn it.

Thank you very much
With regards
Krystian Besler

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web