PrimalSQL is very slow to start

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
tfranciosi
Posts: 5
Joined: Tue Feb 22, 2011 6:52 am

PrimalSQL is very slow to start

Post by tfranciosi » Tue Feb 22, 2011 6:52 am

When starting PrimalSQL 2009, it takes up to 15 minutes for the program to load.

I am logging in remotely via citrix, and I have active connections established.

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

PrimalSQL is very slow to start

Post by davidc » Wed Feb 23, 2011 4:48 am

Are you opening a query file or just running PrimalSQL from a shortcut? In addition, what OS are you running?


Thank you,

David
David
SAPIEN Technologies, Inc.

User avatar
tfranciosi
Posts: 5
Joined: Tue Feb 22, 2011 6:52 am

PrimalSQL is very slow to start

Post by tfranciosi » Wed Feb 23, 2011 6:22 am

I am running Windows Server 2003 R2, 64 bit, sp2

Now I have only one db connection, and it is taking a very long time to return results from a query.

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

PrimalSQL is very slow to start

Post by davidc » Wed Feb 23, 2011 8:21 am

Is the database on the same machine? What provider are you using?
If there is a slow connection, it can take some time for the query builder to build the internal metadata. Try using the SQL Text Document to run your query and see if it makes a difference. In addition, running queries in ReadOnly mode will help speed up the query results.

David
David
SAPIEN Technologies, Inc.

User avatar
tfranciosi
Posts: 5
Joined: Tue Feb 22, 2011 6:52 am

PrimalSQL is very slow to start

Post by tfranciosi » Thu Feb 24, 2011 1:26 am

The db is not on the same machine; but it is on SAN connected with Fiberchannel. There is 1gigabit between servers. I am running the query within the same context.

We are querying several thousand rows within the db. Can PrimalSQL handle that kind of throughput?

I do not believe we have a bandwidth or connectivity problem.

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

PrimalSQL is very slow to start

Post by davidc » Thu Feb 24, 2011 3:29 am

It should be able to handle large amount of rows, but it can also depend on the context of the rows, indexing in the database, or connection type. Is AppData folder mapped to a network location?
David
SAPIEN Technologies, Inc.

User avatar
tfranciosi
Posts: 5
Joined: Tue Feb 22, 2011 6:52 am

PrimalSQL is very slow to start

Post by tfranciosi » Thu Feb 24, 2011 6:11 am

yes

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

PrimalSQL is very slow to start

Post by davidc » Thu Feb 24, 2011 7:36 am

That could be the source of the slow down. It uses the AppData folder as a data cache.
David
SAPIEN Technologies, Inc.

User avatar
tfranciosi
Posts: 5
Joined: Tue Feb 22, 2011 6:52 am

PrimalSQL is very slow to start

Post by tfranciosi » Mon Feb 28, 2011 6:33 am

what is the default path to the appdata folder?

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

PrimalSQL is very slow to start

Post by davidc » Mon Feb 28, 2011 7:19 am

I'm not sure what the path is for Windows Server 2003, but here the paths for the other Windows versions:

Windows 7:
C:Users<username>AppDataRoaming



Windows XP:
C:Documents and Settings<username>Application Data
David
SAPIEN Technologies, Inc.