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 firstname.lastname@example.org
We are a big user of DBARTISAN and would like to get this resolved.