Zum Ende der Metadaten springen
Zum Anfang der Metadaten

Sie zeigen eine alte Version dieser Seite an. Zeigen Sie die aktuelle Version an.

Unterschiede anzeigen Seitenhistorie anzeigen

Version 1 Nächste Version anzeigen »

Bug-WI 5.8.2011
Accomodation search is not able to return a result (due to performance problems)

Bug-Info:
Found in DaVinci-Version: 1049_05
Reproducible on BETA: yes
Location of database: davi-projekt03\sql2005
Version of database: Beta
Last update on database: (e.g. 12/06/2010)

Description (please provide in English):
Using the accomodation search in Genesis won't return any result.

Problem/Screenshots:
Using the accomodation search in Genesis to search for destination "BER":




After clicking on SEARCH the application returs that no hotels are available:

In the sql profiler you can see that following EXEC will end in an timeout:


EXEC [dbo].[TRANSPORT_SEARCH] 1,NULL,{ts '2011-08-11 00:00:00'},0,4,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BER% ',7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL


This causes the empty result.
You can reproduce the behaviour by executing this sql on the Railtour database:

The sql took 17 minutes and returns a big result.
The performance of the accomodation search is too bad. With a big amound of data a result must be returned and displayed in Genesis!


NOTE:
In case of using this exec
EXEC [dbo].[TRANSPORT_SEARCH] 1,NULL,{ts '2011-08-11 00:00:00'},0,4,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'BER% ',7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL
The run takes only 12 seconds!
Following changes were done by Michael Freitag to make the execute faster:
In Transport_Search_For_Catalog:
IF(@tmpOutboundFlightNights IS NULL)
SET @tmpOutboundFlightNights = 0
IF(@tmpInboundFlightNights IS NULL)
SET @tmpInboundFlightNights = 0

  • Keine Stichwörter