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.
midrange.com
