Some Sqlyog Questions

[Tushar Mahale]

Hi there,

1. The SQLYog help document mentions the following feature:

“multithreaded query execution with option to allow multiple query execution simultaneously”

Does multithreaded mean SQLYog creates different sessions for different queries and executes them simultaneously or a query executed in multiple threads?

2. Does SQLYog support internationalization? If not, are there any plans to support the same in the near future?

3. Can it provide any warning when huge amount of data is going to be returned as part of a query result? Does SQLYog consider this scenario?

I would appreciate any feedback on this.

Thanks in advance,

Tushar.

[peterlaursen]

1) the meaning is that you can have more connectsons open at the same time (to the same or different servers) and those different connections operate indepedently. If you enter more queries in the editor (or execute a script with more queries) they will of course execute sequentially. For HTTP-connections only a new connection is created for every query (due to the nature of PHP). Additional connections are created in the background for the 'autocomplete feature' and for certain copy operations.

Was that the answer?

2) We have plans for internationalisation. How many languages we will support officially and when is not decided in detail yet.

Please refer to:

http://webyog.com/faq/content/33/20/en/pla…-of-sqlyog.html

The current plans are: version 6.1 will ship with a Visual Schema Designer, version 6.2 with 'FORMS' (keyboard friendly data entry feature). Also a lot of smaller issues will be adressed in those releases. After that (about 3 months is my best guess) we have not decided on priorities yet.

3) Currently it does not: when physcial + virtual memory is filled up it is likely to crash. We know this but it is not very easy to handle actually – and I think every GUI database client does the same! We will provide manual STOP options everywhere where it still does not exist in near future (planned for 6.1).

[Tushar Mahale]

Thanks Peter,

Just to make sure that I understood what you said regarding multithreading,

If I open one or more “Query Tabs”, there will be one thread executing the queries for each of the 'Query Tab'. Also, all the queries in a single query tab will be executed by a single thread sequentially. Does SQLYog create a new session for each of the query tab(or thread)?

Thanks,

Tushar.

peterlaursen wrote on Aug 7 2007, 09:23 PM:

1) the meaning is that you can have more connectsons open at the same time (to the same or different servers) and those different connections operate indepedently. If you enter more queries in the editor (or execute a script with more queries) they will of course execute sequentially. For HTTP-connections only a new connection is created for every query (due to the nature of PHP). Additional connections are created in the background for the 'autocomplete feature' and for certain copy operations.

Was that the answer?

2) We have plans for internationalisation. How many languages we will support officially and when is not decided in detail yet.

Please refer to:

http://webyog.com/faq/content/33/20/en/pla…-of-sqlyog.html

The current plans are: version 6.1 will ship with a Visual Schema Designer, version 6.2 with 'FORMS' (keyboard friendly data entry feature). Also a lot of smaller issues will be adressed in those releases. After that (about 3 months is my best guess) we have not decided on priorities yet.

3) Currently it does not: when physcial + virtual memory is filled up it is likely to crash. We know this but it is not very easy to handle actually – and I think every GUI database client does the same! We will provide manual STOP options everywhere where it still does not exist in near future (planned for 6.1).

[Manoj]

Hi,

SQLyog uses only one query thread for each connection, and different connections operate indepedently.

[Author]

Posts