Currently in the process of testing an upgrade from 10.1B to 10.2B.
Both of the following queries take about 5 to 10 seconds in 10.1B.
However, the second takes about 2 minutes 17 seconds in 10.2B.
Testing has been carried out using MS Access.
SELECT calendar.analysis_period, customer.customer, calendar.calendar_date, despatch_date.despatch_date, sales_invoice_record.invoice_item, sales_invoice_record.invoiced_area, sales_invoice_record.invoiced_cost_quantity, sales_invoice_record.invoiced_lineal, sales_invoice_record.invoiced_pieces, sales_invoice_record.invoiced_volume, sales_invoice_record.invoiced_weight, sales_invoice_record.sales, sales_invoice_record.margin INTO tmpSalesInvoice
FROM ((sales_invoice_record INNER JOIN calendar ON sales_invoice_record.calendar_key = calendar.calendar_key) INNER JOIN customer ON sales_invoice_record.customer_key = customer.customer_key) INNER JOIN despatch_date ON sales_invoice_record.despatch_date_key = despatch_date.despatch_date_key
WHERE (((calendar.analysis_period)="201003") AND ((customer.customer)<>"SILVS001"));
SELECT calendar.analysis_period, customer.customer, calendar.calendar_date, despatch_date.despatch_date, sales_invoice_record.invoice_item, sales_invoice_record.invoiced_area, sales_invoice_record.invoiced_cost_quantity, sales_invoice_record.invoiced_lineal, sales_invoice_record.invoiced_pieces, sales_invoice_record.invoiced_volume, sales_invoice_record.invoiced_weight, sales_invoice_record.sales, sales_invoice_record.margin INTO tmpSalesInvoice
FROM ((sales_invoice_record INNER JOIN calendar ON sales_invoice_record.calendar_key = calendar.calendar_key) INNER JOIN customer ON sales_invoice_record.customer_key = customer.customer_key) INNER JOIN despatch_date ON sales_invoice_record.despatch_date_key = despatch_date.despatch_date_key
WHERE (((calendar.analysis_period)="201003") AND ((customer.customer)<>"SILVS001" And (customer.customer) Not Like "ZTIM*"));
The only difference between the two statements is that the second statement has some additional criteria...
And (customer.customer) Not Like "ZTIM*"));
Any suggestions why this would cause a differenc in 10.2B?
Regards
Paul
Both of the following queries take about 5 to 10 seconds in 10.1B.
However, the second takes about 2 minutes 17 seconds in 10.2B.
Testing has been carried out using MS Access.
SELECT calendar.analysis_period, customer.customer, calendar.calendar_date, despatch_date.despatch_date, sales_invoice_record.invoice_item, sales_invoice_record.invoiced_area, sales_invoice_record.invoiced_cost_quantity, sales_invoice_record.invoiced_lineal, sales_invoice_record.invoiced_pieces, sales_invoice_record.invoiced_volume, sales_invoice_record.invoiced_weight, sales_invoice_record.sales, sales_invoice_record.margin INTO tmpSalesInvoice
FROM ((sales_invoice_record INNER JOIN calendar ON sales_invoice_record.calendar_key = calendar.calendar_key) INNER JOIN customer ON sales_invoice_record.customer_key = customer.customer_key) INNER JOIN despatch_date ON sales_invoice_record.despatch_date_key = despatch_date.despatch_date_key
WHERE (((calendar.analysis_period)="201003") AND ((customer.customer)<>"SILVS001"));
SELECT calendar.analysis_period, customer.customer, calendar.calendar_date, despatch_date.despatch_date, sales_invoice_record.invoice_item, sales_invoice_record.invoiced_area, sales_invoice_record.invoiced_cost_quantity, sales_invoice_record.invoiced_lineal, sales_invoice_record.invoiced_pieces, sales_invoice_record.invoiced_volume, sales_invoice_record.invoiced_weight, sales_invoice_record.sales, sales_invoice_record.margin INTO tmpSalesInvoice
FROM ((sales_invoice_record INNER JOIN calendar ON sales_invoice_record.calendar_key = calendar.calendar_key) INNER JOIN customer ON sales_invoice_record.customer_key = customer.customer_key) INNER JOIN despatch_date ON sales_invoice_record.despatch_date_key = despatch_date.despatch_date_key
WHERE (((calendar.analysis_period)="201003") AND ((customer.customer)<>"SILVS001" And (customer.customer) Not Like "ZTIM*"));
The only difference between the two statements is that the second statement has some additional criteria...
And (customer.customer) Not Like "ZTIM*"));
Any suggestions why this would cause a differenc in 10.2B?
Regards
Paul