pacumming
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.