INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Multiple database connections in Pervasive 2000i

Multiple database connections in Pervasive 2000i

(OP)
Hi, I'm currently working on a VB/ASP.net project that's using large datasets.  Each time the website loads it gets these large datasets out of pervasive over ODBC what was taking up to 2 mins each time!  To help with loading times I've implemented multithreading.  The idea being that the website has to run 3 separate select statements and it would have to wait for each statement to run before moving onto the next one were as now it runs all 3 at once.  This has solved the problem of loading the data BUT for some reason every now and again one of the threads will hang while filling the dataset.   If you then try and access pervasive though code, pervasive control center or directly on the server it just hangs until you properly kill the task (by restarting the server or though task manager).

Does anyone have any ideas why this might be happening?  Can pervasive 2000i cope with multiple connections from the same application at the same time?

Cheers,
Rene

RE: Multiple database connections in Pervasive 2000i

PSQL 2000i was thread safe for the ODBC driver.  I'm not sure about the OLEDB provider.  What's your connection string?
As far as the actual problem, have you made sure the SQL queries are optimized and are using an index.  This would limit the amount of data to what you actually want/need which could lower the time it takes to run the queries.

Of course, another option is to upgrade the PSQL 2000i to the latest version (currently v10 SP2).  PSQL 2000i went unsupported in March of 2003 so it was probably never tested with VB/ASP.NET.    

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close