Paul,
for every search request the client has first to retrieve a unique handle
from the server. This handle is a primary key in all files in library
ISPHERE. Two request at the same time have different handles. Therefore it`s
no problem to send a request from multiple jobs the same time.
Frank
-----Ursprüngliche Nachricht-----
Von: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Paul Bailey
Gesendet: Donnerstag, 5. September 2013 13:01
An: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries
Betreff: Re: [WDSCI-L] iSphere for WDSCi 7.0 / RDP 8.0+
That's interesting Frank. It seems like your speed advantage is as simple as
making the server do all the work at once rather than passing requests and
results back and forth like FNDSTRPDM does. I've not tried to use the search
yet, due to pressure from on high, but I was wondering whether your system
handles searches from multiple jobs and/or users at the same time?
-Paul.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On
Behalf Of Frank Hildebrandt
Sent: 05 September 2013 09:18
To: 'Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries'
Subject: Re: [WDSCI-L] iSphere for WDSCi 7.0 / RDP 8.0+
Edmund,
the search routines are implemented in RPG IV. There is a service program
FNDSTR in library ISPHERE which is doing this stuff. This service program
will be called by the iSphere client. But this is not the reason for the
high performance. The secret is the way the search request will be
transferred from the iSphere client to the iSphere server and the way the
iSphere client receives the search results from the iSphere server. If you
start the search for a member filter the iSphere client resolves the member
filter. Then with an SQL INSERT the members to search for are transferred to
the iSphere server to table FNDSTRI in library ISPHERE. For 500 members one
SQL INSERT will be generated. If you have 2000 members to search there will
be 4 SQL INSERTs generated. The SQL INSERT will be executed RAPIDLY. After
this the service program FNDSTR is doing the search and places the search
results into table FNDSTRO in library ISPHERE. After this the iSphere client
receives the search results from table FNDSTRO with an SQL SELECT. This is
also be done rapidly.
The iSphere project is open source inclusive the host stuff. The library
ISPHERE contains all sources. For those ones who want to use the iSphere
search for their own projects there is an example in member DEMO in source
file QRPGLESRC in library ISPHERE which illustrates the use of the service
program FNSTR.
Frank
-----Ursprüngliche Nachricht-----
Von: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Edmund Reinhardt
Gesendet: Mittwoch, 4. September 2013 15:59
An: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries
Cc: wdsci-l-bounces@xxxxxxxxxxxx
Betreff: Re: [WDSCI-L] iSphere for WDSCi 7.0 / RDP 8.0+
Frank,
I am just curious, you don't have to tell me any of your trade secrets if
you don't want. But what are you doing to get the performance gains? Feel
free to tell me that it is classified information :-)
Regards,
Edmund (E.H.) Reinhardt
COBOL IDE on AIX, DDS, WebFacing, System i Application Development, Rational
Developer for Power
2D barcode Phone: 1-905-413-3125 | Phone: 1-905-854-6195 IBM
- encoded E-mail: edmund.reinhardt@xxxxxxxxxx
with AIX COBOL:
8200 Warden Ave
contact www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501
Markham, ON L6G 1C7
information "In every thing give thanks: for this is the will of Canada
God in Christ Jesus concerning you." - 1
Thessalonians 5:18
From: "Frank Hildebrandt" <frank.hildebrandt@xxxxxxxxxxxxxxx>
To: "'Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries'" <wdsci-l@xxxxxxxxxxxx>,
Date: 04/09/2013 02:17 AM
Subject: Re: [WDSCI-L] iSphere for WDSCi 7.0 / RDP 8.0+
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
Peter,
the first time after an IPL using iSphere Power Search can take a little
more time. But after the second time you should see the improvement.
On my box i search a member filter containing 637 members. iSphere Power
Search takes 3 seconds and the original RSE Search takes 185 seconds.
For the binding directory issue i think you have deleted the ISPHERE data
area in library QGPL containing the release of the installed OS. Take a look
at the manual.
Frank
-----Ursprüngliche Nachricht-----
Von: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Colpaert, Peter
Gesendet: Mittwoch, 4. September 2013 07:29
An: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries
Betreff: Re: [WDSCI-L] iSphere for WDSCi 7.0 / RDP 8.0+
Hi Frank,
After the re-install, the power search is working.
However, I did a speed comparison between the standard WDSCi search and the
power search, and failed to see any major improvement.
The search was on a source file filter (13 files in 4 libraries), resulting
in 3 hits.
Native "find string": 80 seconds
iSphere power search: 52 seconds
Unless I'm doing something wrong, this isn't quite "60 times faster", or can
one only achieve such improvements on much broader searches?
Also, "edit binding directory" always gives me an empty list, even though
there are entries when using 5250.
Met vriendelijke groeten / Best regards,
Peter Colpaert
Software Engineer - PLM Development Team IT Operations Cluster Benelux,
Philips IT
Philips Consumer Luminaires
Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel: (+32) 3/459 13 17
Email: Peter.Colpaert@xxxxxxxxxxx
Working from home on Wednesdays
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On
Behalf Of Frank Hildebrandt
Sent: dinsdag 3 september 2013 16:05
To: 'Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries'
Subject: Re: [WDSCI-L] iSphere for WDSCi 7.0 / RDP 8.0+
Peter,
there have been another bug, which i have fixed. Please download and install
iSphere once again. Let me know if it works now.
Frank
________________________________
The information contained in this message may be confidential and legally
protected under applicable law. The message is intended solely for the
addressee(s). If you are not the intended recipient, you are hereby notified
that any use, forwarding, dissemination, or reproduction of this message is
strictly prohibited and may be unlawful. If you are not the intended
recipient, please contact the sender by return e-mail and destroy all copies
of the original message.
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Scanned by MailDefender - managed email security from intY -
www.maildefender.net
Important, this email transmission and any files with it are strictly
confidential to the intended recipient and may be legally privileged. Any
views or opinions presented are solely those of the author and do not
necessarily represent those of BHSF. If you are not the intended recipient,
you must not copy, disclose or distribute its contents in any way. If you
have received this e-mail in error, please notify the sender and delete the
e-mail from your system.
We have taken steps to ensure this email and attachments are free from any
virus but do not accept any responsibility once this e-mail has been
transmitted. You should scan any attachments for viruses. No contract may be
concluded on behalf of BHSF Limited by e-mail.
Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham,
B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is
authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
