Performance Issues

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and 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
cuddlywolf
Posts: 5
Joined: Thu May 14, 2009 2:02 am

Performance Issues

Post by cuddlywolf » Thu May 14, 2009 2:02 am

I wrote a basic sql command to query a table and it took a long time for it to return the data.
SQL Statement:
select *From nvd_bustatuswhere nvd_bustatus.nvd_zobjname = 'MS08-076'
Table has ~5 million records, return results about 65000.
In the time that primalsql ran the query I was able to load TOAD, rewrite the sql statement, execute it twice for 2 different filters exporting each results. Even when the resutls did come back, I haven't been able to export the results. This might be my lack of knowledge of the product.

Am I doing something wrong?

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

Performance Issues

Post by davidc » Thu May 14, 2009 2:52 am

Hello

There are some factors that may affect the speed of the query:

The Provider you use may make a difference, for example using the OLE DB Provider vs. the Native Provider.
The content of the query, for example we convert URLs to links.

In order to assist you further please answer the following questions:

What version of PrimalSQL are you currently running?
What type of fields are the results returning?
Are you using a client cursor? (Options-> Output tab)

We are always interesting in improving the product, so your feedback is appreciated.

David davidc2009-05-14 09:53:08
David
SAPIEN Technologies, Inc.

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

Performance Issues

Post by davidc » Thu May 14, 2009 3:15 am

In addition what version of SQL Server are you using and what provider are you connecting with?

Thank you

David
David
SAPIEN Technologies, Inc.

User avatar
cuddlywolf
Posts: 5
Joined: Thu May 14, 2009 2:02 am

Performance Issues

Post by cuddlywolf » Thu May 14, 2009 6:51 am


Version of PrimalSQL is 1.03
Options>Output Tab - Neither of the two options are turned on
Sorry but I don't know the provider information, can you tell me how to find this? I have not changed any default options in the product, set up a sql connection to my sql 2005 server and ran my query against one of my db's.
Data type is primarily varchar, below is a sample set of data:
AGFPBRIGLT11075,MS08-076,8,{patch.verify.error.8 MS08-076} AGFPCLINDT11024,MS08-076,8,{patch.verify.error.8 MS08-076} AGFPFERGDT10981,MS08-076,8,{patch.verify.error.8 MS08-076} AGFPFERGDT10983,MS08-076,8,{patch.verify.error.8 MS08-076}

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

Performance Issues

Post by davidc » Thu May 14, 2009 7:12 am

You can get the Provider information by right clicking on the Database Connection in the "Database Browse"r and select the "Edit" option.

If the "Data Link Properties" window, select the "Provider" tab and your selected provider should be highlighted.

David
David
SAPIEN Technologies, Inc.

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

Performance Issues

Post by davidc » Fri May 15, 2009 6:47 am

Good news, on the next service release you should see a performance improvement (depending on the provider used).
David
David
SAPIEN Technologies, Inc.

User avatar
cuddlywolf
Posts: 5
Joined: Thu May 14, 2009 2:02 am

Performance Issues

Post by cuddlywolf » Fri May 15, 2009 2:24 pm

I looked up and the provider I was using is the Microsoft OLE DB Provider for SQL Server.

That is great news about the performance improvements. You guys do great work thats why I figured I should give some feedback :)

Would you recommnd I use a different provider? I have no allegiance to this one, just the first one I noticed that said sql.

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

Performance Issues

Post by davidc » Mon May 18, 2009 1:41 am

Each provider supports different functionality that may impact your performance with PrimalSQL. Since the providers can be so different it is hard to say which is better without testing it with your own configuration. I
David
SAPIEN Technologies, Inc.