query very very slow

35 views
Skip to first unread message

Ilona Kleiman

unread,
Mar 6, 2022, 5:01:35 AMMar 6
to MapInfo-L
Hi. I am working with mapinfo 19.

If I am doing query between to layers : points intersects polygons, I have result after few seconds. 
BUT if I am adding one more condition :
points intersects polygons AND points citycode <> poligons citycode


so it takes a LOT of time.. (over  hour!!)

Is it bug in mapinfo 19 ? because same query in mapinfo 15 takes few seconds

thank you



Peter Horsbøll Møller

unread,
Mar 7, 2022, 1:38:01 AMMar 7
to mapi...@googlegroups.com

Hi Ilona

 

It’s a side effect of some of the many improvements we made to the SQL language in v2019, especially the Cross Join support that was added.

We did make some further improvements in v2019.3 so make sure you are using the latest version and build: v2019.3 Build 45.

You can download it from here: https://support.precisely.com/product-downloads/item/mapinfo-pro-v2019-3-evaluation-version/

 

There is another workaround that can be applied that also requires v2019.3.

 

Run this statement:

Set SQL Version 1900

 

then run this query

 

From the support documentation:

Purpose

To control the behavior of the join condition evaluation order and support for cross-joins in a session.

 

Syntax

Set SQL Version version_num

version_num is a value of either 1900 or 1700.

 

A version number higher than 1900 will default to 1900, and a version number lower than 1900 will set the SQL version to 1700.

A version less than 1900 will set MapInfo Pro to use the old SQL behavior - join conditions are evaluated from left to right, and support for cross-joins is disabled. To allow cross-joins with SQL version 1700, use the Cross Join keyword explicitly in the SQL Select statement. This would also change the order of evaluation of join conditions from right to left for the particular SQL Select statement.

 

A version number greater than or equal to 1900 will set MapInfo Pro to use the new SQL behavior - join conditions are evaluated from right to left, and support for cross joins is enabled. In this case, you can perform cross-joins with or without using the Cross Join keyword in the SQL Select statement.

Note: The default SQL version is set to 1700, cross-join support is not available by default, and join conditions are evaluated from left to right.

 

Description

Controls the behaviour of the join condition evaluation order and support for cross-joins in a session.

 

Let us know if this helps

 

Peter Horsbøll Møller

www.precisely.com

 

Peter Horsbøll Møller
Principal Sales Engineer - Distinguished Engineer

 

From: mapi...@googlegroups.com <mapi...@googlegroups.com> On Behalf Of Ilona Kleiman
Sent: 6. marts 2022 10:51
To: MapInfo-L <mapi...@googlegroups.com>
Subject: [MI-L] query very very slow

 

This message originated Externally. Use proper judgement and caution with attachments, links, or responses.

 

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/27a4bcca-5dcb-4ad1-b3f5-1a5f015e750dn%40googlegroups.com.

Ilona Kleiman

unread,
Mar 7, 2022, 4:28:23 AMMar 7
to MapInfo-L
Thank you

I'll check it out

понедельник, 7 марта 2022 г. в 08:38:01 UTC+2, Peter Horsbøll Møller:
Reply all
Reply to author
Forward
0 new messages