Seitenvergleich

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":
Image Removed
After clicking on SEARCH the application returs that no hotels are available:
Image Removed
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:
Image Removed
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 = 0Since this Bugfix the accommodation search in Genesis gets a better performance.