Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #5638 > unrolled thread
| Started by | Krystian <softb@softb.pl> |
|---|---|
| First post | 2013-08-05 05:52 -0700 |
| Last post | 2013-08-10 05:26 -0700 |
| Articles | 8 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Krystian <softb@softb.pl> |
|---|---|
| Date | 2013-08-05 05:52 -0700 |
| Subject | SetFilter 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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2013-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]
| From | Krystian <softb@softb.pl> |
|---|---|
| Date | 2013-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2013-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]
| From | Krystian <softb@softb.pl> |
|---|---|
| Date | 2013-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2013-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-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]
| From | Krystian <softb@softb.pl> |
|---|---|
| Date | 2013-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