Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

DBARTISAN gets a not responding message in NT or will not bring back enough rows...

We have NT with about 128mb running DBARTISAN 4.01 against a Sybase database. One of our tables has about 180,000 rows in it of length 500 bytes per record.

The box running Sybase is a UNIX box with sufficient power.

For some reason when we try to do a Select statement to bring back rows
and an Order by clause the system just churns and we gte a "not responding"
message in the NT task manager.

Well we then indexed the fields we had the "order by" clause on and it did help of course and brought back about 1,000 rows in DBARTISAN. This number of rows varies for some reason. Is there a limit on how much DBARTISAN brings back to the workstation. This happens all the time and we do get more rows if we select less fields.

Also we do get "not responding" quite a bit even when doing updates or other statements.

We tried this on several workstations.

Thanks for the help.

A direct email reply would be appreciated to pacumming@mindspring.com

We are a big user of DBARTISAN and would like to get this resolved.

Thanks.
0
pacumming
Asked:
pacumming
1 Solution
 
david_levineCommented:
The Not Responding message doesn't mean that DBArtisan is necessarily having a problem but that's it's waiting for Sybase to process the sql and return its results. To see if it is a DBArtisan issue (which I use constantly but v4.02) do you get different results if running via isql?

Also, if you are bringing back 1000 rows, what are you going to do with the data? I would imagine a better solution would be to bcp out a results set (either an existing table or a "temporary" table which contains your criteria). The bcp will be fast and create, by default, a tab delimited file which can be imported into many different programs.

I'll send this via email as well as you requested. Also, have you contacted Embarcadero or checked their website?

Let me know.
David
0
 
gvijiCommented:
DBArtisan has its own limitations on the number of rows it can bring. The Maximum Worksheet Size      16,384 rows by 256 columns. There is a section in HELP which gives the limitations of DBArtisan.





0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now