Mailing-List: contact users-help@isis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@isis.apache.org
MIME-Version: 1.0
In-Reply-To: <CAHF=ZTDBwkpFmx2WdCSqSnicwCU0D_5zz_H+9p3wVJMKatc+0A@mail.gmail.com>
References: <20171108-170746.12jihah78-msva@mailcc03> <9B5323A02AF8FC44ABA9883B957B35D63409A11F@DCEEXMBX17.ger.win.int.kn>
 <CALJOYLHZMg5G=-HFBVdXsGgF+RvuBuxcUVK9gm-ckC_om1ywbw@mail.gmail.com>
 <CAHF=ZTDYrtiwFyMj1k_JX7cAOafQhtW-N_PO8GQb6d-tB3CSdQ@mail.gmail.com>
 <CALJOYLHQHZcWcwmGxgmO5-+doUkT1XL5nwdti0h3SaiOmyKmUg@mail.gmail.com>
 <CAHF=ZTAxRwO949LB-otEB61gyv48bQVM84g6W62y72EgpPLYgw@mail.gmail.com>
 <CAHF=ZTA01LDY4u=+YL5m1rjaQwQQ7iczugU1MH9AUpdRMoix3g@mail.gmail.com>
 <CALJOYLHi8MV1HU2k9rj3cqNqdmH2DAP4PGWS2bRAWG5Pn4TGiw@mail.gmail.com> <CAHF=ZTDBwkpFmx2WdCSqSnicwCU0D_5zz_H+9p3wVJMKatc+0A@mail.gmail.com>
From: Serdar Hamzaogullari <hasan.serdar@foreks.com>
Date: Fri, 17 Nov 2017 12:15:07 +0300
Message-ID: <CAHF=ZTDO=eQAWnx3afzUDE1yNTYpzM3DTO1Ks5mfDC=N1VprRg@mail.gmail.com>
Subject: Re: Menu getAll action returns table with many sql queries for each entry
To: users@isis.apache.org
Content-Type: multipart/alternative; boundary="001a114feeb64341dc055e2a2cbc"
archived-at: Fri, 17 Nov 2017 09:15:17 -0000

--001a114feeb64341dc055e2a2cbc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello Dan,

Maybe you missed my email. Did you investigate the pagination performance
problem that I indicated in my previous email ?

On Mon, Nov 13, 2017 at 11:50 AM, Serdar Hamzaogullari <
hasan.serdar@foreks.com> wrote:

> Hi Dan,
>
> Thanks for the solution. I tried it and it works fine for get all menu
> action however if I click to any page in the pagination list I see the sq=
l
> queries for all entries again.
>
> I think we need to solve the pagination performance problem.
>
> On Sun, Nov 12, 2017 at 7:57 PM, Dan Haywood <dan@haywood-associates.co.u=
k
> > wrote:
>
>> Hi Serdar,
>>
>> I did.  And here's the thing ... the framework has always done this (at
>> least since 1.8.0, which was the first version I tested).  So, my
>> apologies
>> for indicating otherwise.
>>
>> Clearly we ought to do better here, and I do have a workaround which you
>> could try out.  In your application's DomainApplication (subclass of
>> IsisWicketApplication), add the following to the end of the init() metho=
d:
>>
>>
>> getRequestCycleSettings().setRenderStrategy(RequestCycleSett
>> ings.RenderStrategy.REDIRECT_TO_BUFFER);
>>
>> By default we use the REDIRECT_TO_RENDER strategy ... I dimly recall my
>> rationale as being that it's "safer"; this Wicket wiki page [1] explains
>> the difference.  However, this is what causes the 1+N loading that we se=
e.
>> A first Isis/DN session is used to select the objects, and mementos for
>> all
>> retrieved objects are captured.  This first session is then closed.  On
>> render, we then open a new Isis/DN session and use those mementos to
>> retrieve all objects one by one.
>>
>> Using REDIRECT_TO_BUFFER means that all the work is done in a single
>> session, avoiding the issue.
>>
>> My limited testing didn't throw up any adverse effects to switching to
>> REDIRECT_TO_BUFFER, and I've raised a ticket [2] to explore changing thi=
s
>> behaviour.
>>
>> Thanks for raising this, let me know how you get on.
>>
>> Cheers
>> Dan
>>
>> [1] https://cwiki.apache.org/confluence/display/WICKET/Render+strategies
>> [2] https://issues.apache.org/jira/browse/ISIS-1774
>>
>>
>> On Sat, 11 Nov 2017 at 20:30 Serdar Hamzaogullari <
>> hasan.serdar@foreks.com>
>> wrote:
>>
>> > Hello Dan,
>> >
>> > Did you have a chance to take look at my github example app
>> >
>> > 9 Kas 2017 Per, saat 16:22 tarihinde Serdar Hamzaogullari <
>> > hasan.serdar@foreks.com> =C5=9Funu yazd=C4=B1:
>> >
>> > > Hi Dan,
>> > >
>> > > Here is a complete example of the problem
>> > >
>> > > https://github.com/radresian/apache-isis-sample
>> > >
>> > > After running the application Click the ProfilePreferences Menu ->
>> List
>> > > All, then you will see the SQL queries for each entry at the console
>> > logs...
>> > >
>> > > On Thu, Nov 9, 2017 at 2:17 AM, Dan Haywood <
>> > dan@haywood-associates.co.uk>
>> > > wrote:
>> > >
>> > >> Hmm, looks ok.
>> > >>
>> > >> Can you upload an example app to github so I can pull it down and
>> take a
>> > >> closer look?
>> > >>
>> > >> Thx
>> > >> Dan
>> > >>
>> > >> On Wed, 8 Nov 2017 at 23:12 Serdar Hamzaogullari <
>> > hasan.serdar@foreks.com
>> > >> >
>> > >> wrote:
>> > >>
>> > >> > Hi J=C3=B6rg,
>> > >> >
>> > >> > IdGeneratorStrategy.IDENTITY did not help. Same result.
>> > >> >
>> > >> > Hi Dan,
>> > >> >
>> > >> > Here is my repository:
>> > >> >
>> > >> >
>> > >> > @DomainService(
>> > >> >         nature =3D NatureOfService.DOMAIN,
>> > >> >         repositoryFor =3D ProfilePreferences.class
>> > >> > )
>> > >> > public class ProfilePreferencesRepository {
>> > >> >
>> > >> >     public List<ProfilePreferences> listAll() {
>> > >> >         return
>> > repositoryService.allInstances(ProfilePreferences.class);
>> > >> >     }
>> > >> >
>> > >> >     public ProfilePreferences get(final String name) {
>> > >> >         return repositoryService.uniqueMatch(
>> > >> >                 new QueryDefault<>(
>> > >> >                         ProfilePreferences.class,
>> > >> >                         "get",
>> > >> >                         "name", name));
>> > >> >     }
>> > >> >
>> > >> >     public ProfilePreferences create(final String name) {
>> > >> >         final ProfilePreferences object =3D new
>> > ProfilePreferences(name);
>> > >> >         serviceRegistry.injectServicesInto(object);
>> > >> >         repositoryService.persist(object);
>> > >> >         return object;
>> > >> >     }
>> > >> >
>> > >> >     @javax.inject.Inject
>> > >> >     RepositoryService repositoryService;
>> > >> >     @javax.inject.Inject
>> > >> >     ServiceRegistry2 serviceRegistry;
>> > >> > }
>> > >> >
>> > >> >
>> > >> >
>> > >> > On Wed, Nov 8, 2017 at 8:16 PM, Dan Haywood <
>> > >> dan@haywood-associates.co.uk>
>> > >> > wrote:
>> > >> >
>> > >> > > Hi Serdar,
>> > >> > >
>> > >> > > can you show us your repository implementation?
>> > >> > >
>> > >> > > I'm wondering why you have defined a query called "Get", I
>> wonder if
>> > >> it's
>> > >> > > being used in that repo (I don't think it should be, if so)
>> > >> > >
>> > >> > > Ta
>> > >> > > Dan
>> > >> > >
>> > >> > >
>> > >> > > On Wed, 8 Nov 2017 at 17:09 Rade, Joerg / Kuehne + Nagel / Ham
>> > GI-DP <
>> > >> > > Joerg.Rade@kuehne-nagel.com> wrote:
>> > >> > >
>> > >> > > > Hi Serdar,
>> > >> > > >
>> > >> > > > did you consider:
>> > >> > > >
>> > >> > > > @javax.jdo.annotations.DatastoreIdentity(
>> > >> > > >         strategy =3D
>> > >> javax.jdo.annotations.IdGeneratorStrategy.IDENTITY,
>> > >> > > >         column =3D "id")
>> > >> > > >
>> > >> > > > instead of:
>> > >> > > >
>> > >> > > > @PrimaryKey?
>> > >> > > >
>> > >> > > > Best regards
>> > >> > > > J=C3=B6rg
>> > >> > > >
>> > >> > > > -----Urspr=C3=BCngliche Nachricht-----
>> > >> > > > Von: Serdar Hamzaogullari [mailto:hasan.serdar@foreks.com]
>> > >> > > > Gesendet: Mittwoch, 8. November 2017 17:07
>> > >> > > > An: users@isis.apache.org
>> > >> > > > Betreff: Menu getAll action returns table with many sql queri=
es
>> > for
>> > >> > each
>> > >> > > > entry
>> > >> > > >
>> > >> > > > Hi,
>> > >> > > >
>> > >> > > > I have a menu action like this, listAll action:
>> > >> > > >
>> > >> > > >
>> > >> > > > @DomainService(
>> > >> > > >         nature =3D NatureOfService.VIEW_MENU_ONLY,
>> > >> > > >         objectType =3D "profile-preferences-services",
>> > >> > > >         repositoryFor =3D ProfilePreferences.class
>> > >> > > > )
>> > >> > > > @DomainServiceLayout(
>> > >> > > >         named =3D "Profile Preferences",
>> > >> > > >         menuOrder =3D "3"
>> > >> > > > )
>> > >> > > > public class ProfilePreferencesMenu {
>> > >> > > >
>> > >> > > >     @Action(semantics =3D SemanticsOf.SAFE)
>> > >> > > >     @ActionLayout(bookmarking =3D BookmarkPolicy.AS_ROOT)
>> > >> > > >     @MemberOrder(sequence =3D "1")
>> > >> > > >     public List<ProfilePreferences> listAll() {
>> > >> > > >         return profilePreferencesRepository.listAll();
>> > >> > > >     }
>> > >> > > > .
>> > >> > > > .
>> > >> > > > .
>> > >> > > >
>> > >> > > > My Entity is that:
>> > >> > > >
>> > >> > > >
>> > >> > > > @javax.jdo.annotations.PersistenceCapable(
>> > >> > > >         identityType=3DIdentityType.APPLICATION,
>> > >> > > >         table=3D"profile_preferences",
>> > >> > > >         schema =3D "dbo"
>> > >> > > > )
>> > >> > > > @javax.jdo.annotations.Version(
>> > >> > > >         strategy=3D VersionStrategy.VERSION_NUMBER,
>> > >> > > >         column=3D"version")
>> > >> > > > @javax.jdo.annotations.Queries({
>> > >> > > >         @javax.jdo.annotations.Query(
>> > >> > > >                 name =3D "get",
>> > >> > > >                 value =3D "SELECT "
>> > >> > > >                         + "FROM
>> > >> > > > com.foreks.user.settings.domain.preferences.ProfilePreference=
s
>> "
>> > >> > > >                         + "WHERE profileName.equals(:name)")
>> > >> > > > })
>> > >> > > > @DomainObject(
>> > >> > > >         objectType =3D "profile-preferences"
>> > >> > > > )
>> > >> > > > public class ProfilePreferences implements
>> > >> > > Comparable<ProfilePreferences> {
>> > >> > > >
>> > >> > > >     public ProfilePreferences(final String profileName) {
>> > >> > > >         setProfileName(profileName);
>> > >> > > >     }
>> > >> > > >
>> > >> > > >     @javax.jdo.annotations.Column(allowsNull =3D "false",
>> length=3D
>> > 150)
>> > >> > > >     @PrimaryKey
>> > >> > > >     @Getter @Setter
>> > >> > > >     @Title(prepend =3D "Profile Preferences: ")
>> > >> > > >     private String profileName;
>> > >> > > >
>> > >> > > >     @javax.jdo.annotations.Column(allowsNull =3D "true", leng=
th
>> =3D
>> > >> 4000)
>> > >> > > >     @Property(editing =3D Editing.ENABLED,hidden =3D
>> Where.ALL_TABLES)
>> > >> > > >     @Getter @Setter
>> > >> > > >     private String preferences;
>> > >> > > >
>> > >> > > >     //region > delete (action)
>> > >> > > >     @Action(semantics =3D SemanticsOf.NON_IDEMPOTENT_ARE
>> _YOU_SURE)
>> > >> > > >     public void delete() {
>> > >> > > >         final String title =3D titleService.titleOf(this);
>> > >> > > >         messageService.informUser(String.format("'%s'
>> deleted",
>> > >> > title));
>> > >> > > >         repositoryService.remove(this);
>> > >> > > >     }
>> > >> > > >     //endregion
>> > >> > > >
>> > >> > > >     //region > delete (action)
>> > >> > > >     @Action(semantics =3D SemanticsOf.NON_IDEMPOTENT)
>> > >> > > >     public ProfilePreferences copy(@ParameterLayout(named=3D"=
P
>> rofile
>> > >> > > Name")
>> > >> > > > String name) {
>> > >> > > >         final ProfilePreferences object =3D new
>> > >> ProfilePreferences(name);
>> > >> > > >         object.setPreferences(preferences);
>> > >> > > >         repositoryService.persist(object);
>> > >> > > >         return object;
>> > >> > > >     }
>> > >> > > >     //endregion
>> > >> > > >
>> > >> > > >     //region > toString, compareTo
>> > >> > > >     @Override
>> > >> > > >     public String toString() {
>> > >> > > >         return ObjectContracts.toString(this, "profileName");
>> > >> > > >     }
>> > >> > > >
>> > >> > > >     @Override
>> > >> > > >     public int compareTo(final ProfilePreferences other) {
>> > >> > > >         return ObjectContracts.compare(this, other,
>> > "profileName");
>> > >> > > >     }
>> > >> > > >     //endregion
>> > >> > > >
>> > >> > > >     //region > injected services
>> > >> > > >     @javax.inject.Inject
>> > >> > > >     RepositoryService repositoryService;
>> > >> > > >
>> > >> > > >     @javax.inject.Inject
>> > >> > > >     TitleService titleService;
>> > >> > > >
>> > >> > > >     @javax.inject.Inject
>> > >> > > >     MessageService messageService;
>> > >> > > >     //endregion
>> > >> > > >
>> > >> > > > }
>> > >> > > >
>> > >> > > >
>> > >> > > > When I click the List All action from the wicket viewer menu,
>> > server
>> > >> > logs
>> > >> > > > this SQL queries:
>> > >> > > >
>> > >> > > > 19:03:07,334  [Native               http-nio-8080-exec-4 DEBU=
G]
>> > >> SELECT
>> > >> > > > 'com.foreks.user.settings.domain.preferences.ProfilePreferen
>> ces'
>> > AS
>> > >> > > > NUCLEUS_TYPE,A0.preferences,A0.profileName,A0.version FROM
>> > >> > > > dbo.profile_preferences A0
>> > >> > > > 19:03:07,436  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'ahl'>
>> > >> > > > 19:03:07,442  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'akbank'>
>> > >> > > > 19:03:07,448  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'bmd'>
>> > >> > > > 19:03:07,454  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'DELTA'>
>> > >> > > > 19:03:07,460  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'foreks'>
>> > >> > > > 19:03:07,466  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'halky'>
>> > >> > > > 19:03:07,472  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'hcbs'>
>> > >> > > > 19:03:07,477  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'issanal'>
>> > >> > > > 19:03:07,483  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'marbas'>
>> > >> > > > 19:03:07,489  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'odeabank'>
>> > >> > > > 19:03:07,495  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'odtu'>
>> > >> > > > 19:03:07,500  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'osmanli'>
>> > >> > > > 19:03:07,506  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'piramit'>
>> > >> > > > 19:03:07,512  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'tebsanal'>
>> > >> > > > 19:03:07,517  [Native               http-nio-8080-exec-5 DEBU=
G]
>> > >> SELECT
>> > >> > > > A0.preferences,A0.version FROM dbo.profile_preferences A0 WHE=
RE
>> > >> > > > A0.profileName =3D <'ZIRAAT'>
>> > >> > > >
>> > >> > > >
>> > >> > > > There is a query for each entity.  The firs query
>> > >> > > >
>> > >> > > >  SELECT
>> > >> > 'com.foreks.user.settings.domain.preferences.ProfilePreferences'
>> > >> > > > AS NUCLEUS_TYPE,A0.preferences,A0.profileName,A0.version FROM
>> > >> > > > dbo.profile_preferences A0
>> > >> > > >
>> > >> > > > should be enough. Query for every entity becomes a performanc=
e
>> > >> problem.
>> > >> > > > How can I prevent this behavior ? Is there some thing wrong o=
r
>> > >> missing
>> > >> > in
>> > >> > > > my Entity Class or Menu Action Class ?
>> > >> > > >
>> > >> > > > Help please :)
>> > >> > > >
>> > >> > > > --
>> > >> > > >  <http://www.foreksmobile.com/redirect.html>
>> > >> > > >
>> > >> > > > P
>> > >> > > >
>> > >> > > > Bu mesaji yazdirmadan =C3=B6nce =C3=A7evreye olan sorumlulugu=
muzu bir kez
>> > daha
>> > >> > > > d=C3=BCs=C3=BCnelim.
>> > >> > > > Please consider the environment before printing this e-mail.
>> > >> > > >
>> > >> > > > Bu elektronik posta ve onunla iletilen b=C3=BCt=C3=BCn dosyal=
ar sadece
>> > >> > g=C3=B6ndericisi
>> > >> > > > taraf=C4=B1ndan almas=C4=B1 ama=C3=A7lanan yetkili ger=C3=A7e=
k ya da t=C3=BCzel ki=C5=9Finin
>> > >> > kullan=C4=B1m=C4=B1
>> > >> > > > i=C3=A7indir. E=C4=9Fer s=C3=B6z konusu yetkili al=C4=B1c=C4=
=B1 de=C4=9Filseniz bu elektronik
>> > >> > postan=C4=B1n
>> > >> > > > i=C3=A7eri=C4=9Fini a=C3=A7=C4=B1klaman=C4=B1z, kopyalaman=C4=
=B1z, y=C3=B6nlendirmeniz ve
>> kullanman=C4=B1z
>> > >> > > > kesinlikle yasakt=C4=B1r ve bu elektronik postay=C4=B1 derhal=
 silmeniz
>> > >> > > gerekmektedir.
>> > >> > > > FOREKS bu mesaj=C4=B1n i=C3=A7erdi=C4=9Fi bilgilerin do=C4=9F=
rulu=C4=9Fu veya eksiksiz
>> > oldu=C4=9Fu
>> > >> > > > konusunda herhangi bir garanti vermemektedir. Bu nedenle bu
>> > >> bilgilerin
>> > >> > ne
>> > >> > > > =C5=9Fekilde olursa olsun i=C3=A7eri=C4=9Finden, iletilmesind=
en, al=C4=B1nmas=C4=B1ndan
>> ve
>> > >> > > > saklanmas=C4=B1ndan sorumlu de=C4=9Fildir. Bu mesajdaki g=C3=
=B6r=C3=BC=C5=9Fler yaln=C4=B1zca
>> > >> > g=C3=B6nderen
>> > >> > > > ki=C5=9Fiye aittir ve FOREKS'in g=C3=B6r=C3=BC=C5=9Flerini ya=
ns=C4=B1tmayabilir.
>> > >> > > > Bu e-posta bilinen b=C3=BCt=C3=BCn bilgisayar vir=C3=BCslerin=
e kar=C5=9F=C4=B1
>> taranm=C4=B1=C5=9Ft=C4=B1r.
>> > >> > > > *
>> > >> > > > This e-mail and any files transmitted with it are confidentia=
l
>> and
>> > >> > > > intended solely for the use of the individual or entity to wh=
om
>> > they
>> > >> > are
>> > >> > > > addressed.
>> > >> > > > If you are not the intended recipient you are hereby notified
>> that
>> > >> any
>> > >> > > > dissemination, forwarding, copying or use of any of the
>> > information
>> > >> is
>> > >> > > > strictly prohibited, and the e-mail should immediately be
>> deleted.
>> > >> > FOREKS
>> > >> > > > makes no warranty as to the accuracy or completeness of any
>> > >> information
>> > >> > > > contained in this message and hereby excludes any liability o=
f
>> any
>> > >> kind
>> > >> > > for
>> > >> > > > the information contained therein or for the information
>> > >> transmission,
>> > >> > > > reception, storage or use of such in any way whatsoever. The
>> > >> opinions
>> > >> > > > expressed in this message belong to sender alone and may not
>> > >> > necessarily
>> > >> > > > reflect the opinions of FOREKS.
>> > >> > > > This e-mail has been scanned for all known computer viruses.
>> > >> > > >
>> > >> > > > K=C3=BChne + Nagel (AG & Co.) KG
>> > >> > > > Rechtsform: Kommanditgesellschaft, Bremen HRA 21928,
>> USt-IdNr.: DE
>> > >> > > > 812773878.
>> > >> > > > Gesch=C3=A4ftsleitung K=C3=BChne + Nagel (AG & Co.) KG: Dr. H=
ansj=C3=B6rg Rodi
>> > >> (Vors.
>> > >> > ),
>> > >> > > > Martin Brinkmann, Holger Ketz, Jan-Hendrik K=C3=B6stergarten,
>> Nicholas
>> > >> > Minde,
>> > >> > > > Michael Nebel, Lars Wedel, Matthias Weiner.
>> > >> > > > Pers=C3=B6nlich haftende Gesellschafterin: K=C3=BChne & Nagel=
 A.G.,
>> > >> Rechtsform:
>> > >> > > > Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 1874=
5,
>> > >> > > > Gesch=C3=A4ftsf=C3=BChrendes Verwaltungsratsmitglied: Karl Ge=
rnandt.
>> > >> > > > Gesch=C3=A4ftsleitung Region Zentral- und Osteuropa: Dr. Hans=
j=C3=B6rg
>> Rodi
>> > >> > > (Vors.),
>> > >> > > > Thierry Held, Uwe H=C3=B6tt, Richard Huhn, Holger Ketz, Jan-H=
endrik
>> > >> > > > K=C3=B6stergarten, Jan Kunze, Michael Nebel, Guillaume Sauzed=
de,
>> > Mustafa
>> > >> > > Sener.
>> > >> > > >
>> > >> > > > Wir arbeiten ausschlie=C3=9Flich auf Grundlage der Allgemeine=
n
>> > Deutschen
>> > >> > > > Spediteurbedingungen 2017 (ADSp 2017). Hinweis: Die ADSp 2017
>> > >> weichen
>> > >> > in
>> > >> > > > Ziffer 23 hinsichtlich des Haftungsh=C3=B6chstbetrages f=C3=
=BCr
>> G=C3=BCtersch=C3=A4den
>> > >> (=C2=A7
>> > >> > 431
>> > >> > > > HGB) vom Gesetz ab, indem sie die Haftung bei multimodalen
>> > >> Transporten
>> > >> > > > unter Einschluss einer Seebef=C3=B6rderung und bei unbekannte=
m
>> > Schadenort
>> > >> > auf
>> > >> > > 2
>> > >> > > > SZR/kg und im =C3=9Cbrigen die Regelhaftung von 8,33 SZR/kg
>> zus=C3=A4tzlich
>> > >> auf
>> > >> > > 1,25
>> > >> > > > Millionen Euro je Schadenfall sowie 2,5 Millionen Euro je
>> > >> > > Schadenereignis,
>> > >> > > > mindestens aber 2 SZR/kg, beschr=C3=A4nken. Die ADSp sind auf
>> unserer
>> > >> > Webseite
>> > >> > > > als Download erh=C3=A4ltlich. Auf Anfrage senden wir Ihnen di=
ese
>> auch
>> > >> gerne
>> > >> > > zu.
>> > >> > > >
>> > >> > >
>> > >> >
>> > >> > --
>> > >> >  <http://www.foreksmobile.com/redirect.html>
>> > >> >
>> > >> > P
>> > >> >
>> > >> > Bu mesaji yazdirmadan =C3=B6nce =C3=A7evreye olan sorumlulugumuzu=
 bir kez
>> daha
>> > >> > d=C3=BCs=C3=BCnelim.
>> > >> > Please consider the environment before printing this e-mail.
>> > >> >
>> > >> > Bu elektronik posta ve onunla iletilen b=C3=BCt=C3=BCn dosyalar s=
adece
>> > g=C3=B6ndericisi
>> > >> > taraf=C4=B1ndan almas=C4=B1 ama=C3=A7lanan yetkili ger=C3=A7ek ya=
 da t=C3=BCzel ki=C5=9Finin
>> > kullan=C4=B1m=C4=B1
>> > >> > i=C3=A7indir. E=C4=9Fer s=C3=B6z konusu yetkili al=C4=B1c=C4=B1 d=
e=C4=9Filseniz bu elektronik
>> > postan=C4=B1n
>> > >> > i=C3=A7eri=C4=9Fini a=C3=A7=C4=B1klaman=C4=B1z, kopyalaman=C4=B1z=
, y=C3=B6nlendirmeniz ve kullanman=C4=B1z
>> > >> > kesinlikle yasakt=C4=B1r ve bu elektronik postay=C4=B1 derhal sil=
meniz
>> > >> gerekmektedir.
>> > >> > FOREKS bu mesaj=C4=B1n i=C3=A7erdi=C4=9Fi bilgilerin do=C4=9Frulu=
=C4=9Fu veya eksiksiz
>> oldu=C4=9Fu
>> > >> > konusunda herhangi bir garanti vermemektedir. Bu nedenle bu
>> bilgilerin
>> > >> ne
>> > >> > =C5=9Fekilde olursa olsun i=C3=A7eri=C4=9Finden, iletilmesinden, =
al=C4=B1nmas=C4=B1ndan ve
>> > >> > saklanmas=C4=B1ndan sorumlu de=C4=9Fildir. Bu mesajdaki g=C3=B6r=
=C3=BC=C5=9Fler yaln=C4=B1zca
>> > g=C3=B6nderen
>> > >> > ki=C5=9Fiye aittir ve FOREKS'in g=C3=B6r=C3=BC=C5=9Flerini yans=
=C4=B1tmayabilir.
>> > >> > Bu e-posta bilinen b=C3=BCt=C3=BCn bilgisayar vir=C3=BCslerine ka=
r=C5=9F=C4=B1 taranm=C4=B1=C5=9Ft=C4=B1r.
>> > >> > *
>> > >> > This e-mail and any files transmitted with it are confidential an=
d
>> > >> intended
>> > >> > solely for the use of the individual or entity to whom they are
>> > >> addressed.
>> > >> > If you are not the intended recipient you are hereby notified tha=
t
>> any
>> > >> > dissemination, forwarding, copying or use of any of the
>> information is
>> > >> > strictly prohibited, and the e-mail should immediately be deleted=
.
>> > >> FOREKS
>> > >> > makes
>> > >> > no warranty as to the accuracy or completeness of any information
>> > >> contained
>> > >> > in this message and hereby excludes any liability of any kind for
>> the
>> > >> > information contained therein or for the information transmission=
,
>> > >> > reception, storage or use of such in any way whatsoever. The
>> opinions
>> > >> > expressed in this message belong to sender alone and may not
>> > necessarily
>> > >> > reflect the opinions of FOREKS.
>> > >> > This e-mail has been scanned for all known computer viruses.
>> > >> >
>> > >>
>> > >
>> > >
>> >
>> > --
>> >  <http://www.foreksmobile.com/redirect.html>
>> >
>> > P
>> >
>> > Bu mesaji yazdirmadan =C3=B6nce =C3=A7evreye olan sorumlulugumuzu bir =
kez daha
>> > d=C3=BCs=C3=BCnelim.
>> > Please consider the environment before printing this e-mail.
>> >
>> > Bu elektronik posta ve onunla iletilen b=C3=BCt=C3=BCn dosyalar sadece=
 g=C3=B6ndericisi
>> > taraf=C4=B1ndan almas=C4=B1 ama=C3=A7lanan yetkili ger=C3=A7ek ya da t=
=C3=BCzel ki=C5=9Finin kullan=C4=B1m=C4=B1
>> > i=C3=A7indir. E=C4=9Fer s=C3=B6z konusu yetkili al=C4=B1c=C4=B1 de=C4=
=9Filseniz bu elektronik postan=C4=B1n
>> > i=C3=A7eri=C4=9Fini a=C3=A7=C4=B1klaman=C4=B1z, kopyalaman=C4=B1z, y=
=C3=B6nlendirmeniz ve kullanman=C4=B1z
>> > kesinlikle yasakt=C4=B1r ve bu elektronik postay=C4=B1 derhal silmeniz
>> gerekmektedir.
>> > FOREKS bu mesaj=C4=B1n i=C3=A7erdi=C4=9Fi bilgilerin do=C4=9Frulu=C4=
=9Fu veya eksiksiz oldu=C4=9Fu
>> > konusunda herhangi bir garanti vermemektedir. Bu nedenle bu bilgilerin
>> ne
>> > =C5=9Fekilde olursa olsun i=C3=A7eri=C4=9Finden, iletilmesinden, al=C4=
=B1nmas=C4=B1ndan ve
>> > saklanmas=C4=B1ndan sorumlu de=C4=9Fildir. Bu mesajdaki g=C3=B6r=C3=BC=
=C5=9Fler yaln=C4=B1zca g=C3=B6nderen
>> > ki=C5=9Fiye aittir ve FOREKS'in g=C3=B6r=C3=BC=C5=9Flerini yans=C4=B1t=
mayabilir.
>> > Bu e-posta bilinen b=C3=BCt=C3=BCn bilgisayar vir=C3=BCslerine kar=C5=
=9F=C4=B1 taranm=C4=B1=C5=9Ft=C4=B1r.
>> > *
>> > This e-mail and any files transmitted with it are confidential and
>> intended
>> > solely for the use of the individual or entity to whom they are
>> addressed.
>> > If you are not the intended recipient you are hereby notified that any
>> > dissemination, forwarding, copying or use of any of the information is
>> > strictly prohibited, and the e-mail should immediately be deleted.
>> FOREKS
>> > makes
>> > no warranty as to the accuracy or completeness of any information
>> contained
>> > in this message and hereby excludes any liability of any kind for the
>> > information contained therein or for the information transmission,
>> > reception, storage or use of such in any way whatsoever. The opinions
>> > expressed in this message belong to sender alone and may not necessari=
ly
>> > reflect the opinions of FOREKS.
>> > This e-mail has been scanned for all known computer viruses.
>> >
>>
>
>

--=20
 <http://www.foreksmobile.com/redirect.html>

P

Bu mesaji yazdirmadan =C3=B6nce =C3=A7evreye olan sorumlulugumuzu bir kez d=
aha=20
d=C3=BCs=C3=BCnelim.=20
Please consider the environment before printing this e-mail.

Bu elektronik posta ve onunla iletilen b=C3=BCt=C3=BCn dosyalar sadece g=C3=
=B6ndericisi=20
taraf=C4=B1ndan almas=C4=B1 ama=C3=A7lanan yetkili ger=C3=A7ek ya da t=C3=
=BCzel ki=C5=9Finin kullan=C4=B1m=C4=B1=20
i=C3=A7indir. E=C4=9Fer s=C3=B6z konusu yetkili al=C4=B1c=C4=B1 de=C4=9Fils=
eniz bu elektronik postan=C4=B1n=20
i=C3=A7eri=C4=9Fini a=C3=A7=C4=B1klaman=C4=B1z, kopyalaman=C4=B1z, y=C3=B6n=
lendirmeniz ve kullanman=C4=B1z=20
kesinlikle yasakt=C4=B1r ve bu elektronik postay=C4=B1 derhal silmeniz gere=
kmektedir.=20
FOREKS bu mesaj=C4=B1n i=C3=A7erdi=C4=9Fi bilgilerin do=C4=9Frulu=C4=9Fu ve=
ya eksiksiz oldu=C4=9Fu=20
konusunda herhangi bir garanti vermemektedir. Bu nedenle bu bilgilerin ne=
=20
=C5=9Fekilde olursa olsun i=C3=A7eri=C4=9Finden, iletilmesinden, al=C4=B1nm=
as=C4=B1ndan ve=20
saklanmas=C4=B1ndan sorumlu de=C4=9Fildir. Bu mesajdaki g=C3=B6r=C3=BC=C5=
=9Fler yaln=C4=B1zca g=C3=B6nderen=20
ki=C5=9Fiye aittir ve FOREKS'in g=C3=B6r=C3=BC=C5=9Flerini yans=C4=B1tmayab=
ilir.=20
Bu e-posta bilinen b=C3=BCt=C3=BCn bilgisayar vir=C3=BCslerine kar=C5=9F=C4=
=B1 taranm=C4=B1=C5=9Ft=C4=B1r.=20
*=20
This e-mail and any files transmitted with it are confidential and intended=
=20
solely for the use of the individual or entity to whom they are addressed.=
=20
If you are not the intended recipient you are hereby notified that any=20
dissemination, forwarding, copying or use of any of the information is=20
strictly prohibited, and the e-mail should immediately be deleted. FOREKS m=
akes=20
no warranty as to the accuracy or completeness of any information contained=
=20
in this message and hereby excludes any liability of any kind for the=20
information contained therein or for the information transmission,=20
reception, storage or use of such in any way whatsoever. The opinions=20
expressed in this message belong to sender alone and may not necessarily=20
reflect the opinions of FOREKS.=20
This e-mail has been scanned for all known computer viruses.

--001a114feeb64341dc055e2a2cbc--