PrimalSQL quits responding when writing query

Support for all customers who have purchased a PrimalSQL product license. This forum does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
jjdynamite
Posts: 41
Joined: Tue May 19, 2009 12:31 am

PrimalSQL quits responding when writing query

Post by jjdynamite » Tue Aug 18, 2009 12:52 am

In the new versions of PrimalSQL (1.0.6 & 1.0.7), PrimalSQL freezes for 15-30 seconds when trying to pull up the 'quick pick' menu for SQL Edit or within a SQL document. Normally, it would help out by bringing up the tables/fields that are available in the database but now all it does is hender work. Is there a way to disable this feature until it can be repaired?

Database: Oracle 9i
Client O/S: Windows Vista Business x64
Oracle Client: 11g (32-bit)

User avatar
davidc
Posts: 5398
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL quits responding when writing query

Post by davidc » Tue Aug 18, 2009 1:45 am

We will look into this issue further. The information it is displaying should be cached, thus it is strange that there is such large delay. Also this part of the program has not changed in the latest releases.


Please answer the following questions in order for us to pin point the problem.

-Does this occur on other databases?
-Does this also occur on a simple Select statement?

Please check if the "Store Browser Information" option is checked in the Options Window, under the "Database Browser" Tab.


Thank you,

David
David
SAPIEN Technologies, Inc.

User avatar
davidc
Posts: 5398
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL quits responding when writing query

Post by davidc » Tue Aug 18, 2009 1:48 am

To answer your question, there is no option to disable the feature.
David
David
SAPIEN Technologies, Inc.

User avatar
jjdynamite
Posts: 41
Joined: Tue May 19, 2009 12:31 am

PrimalSQL quits responding when writing query

Post by jjdynamite » Tue Aug 18, 2009 2:12 am

-Does this occur on other databases? YES
-Does this also occur on a simple Select statement? YES



It seems to happen more with larger databases with more than 10-15 tables. The ones that I am working with now have in the neighborhood of 35+ tables. Could this be causing the issues?

I also checked and the option for 'Store Database Browser Information' is selected.

User avatar
davidc
Posts: 5398
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL quits responding when writing query

Post by davidc » Tue Aug 18, 2009 2:26 am

Can you zip and email the Database Browser cache information to support@sapien.com? This will allow us to test the PrimalSense without having access to the database.

You can find the cache file (.dat) by going to the Application Data folder:

Vista Path:
C:Users<UserName>AppDataRoamingSAPIENDataSources

The cache (.dat) file will have the same name as the Database connection.

Thank you,

David
David
SAPIEN Technologies, Inc.

User avatar
jjdynamite
Posts: 41
Joined: Tue May 19, 2009 12:31 am

PrimalSQL quits responding when writing query

Post by jjdynamite » Tue Aug 18, 2009 2:33 am

David, The file has been sent to you.

User avatar
davidc
Posts: 5398
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL quits responding when writing query

Post by davidc » Tue Aug 18, 2009 4:30 am

This issue will be resolved in the next service release. You should see an improvement in the PrimalSense speed when dealing with large databases.
David
David
SAPIEN Technologies, Inc.