× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.