comp.lang.idl-pvwave archive: archive » Dataminer: faster way to get all records in a IDLdbRecordset table?

Home » Public Forums » archive » Dataminer: faster way to get all records in a IDLdbRecordset table?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Dataminer: faster way to get all records in a IDLdbRecordset table? [message #36461]

Wed, 17 September 2003 08:38

timothy.williams
Messages: 20
Registered: October 2001

Junior Member

I want to put the records in a database table into an IDL table
widget. For fairly large tables, (> ~1500 rows), it's fairly slow and
I get "Not responding" in the Task Manager for awhile while I'm
getting each record. Here's what I'm doing now:

ors=obj_new('IDLdbRecordset', table=tablename)
status=ors->moveCursor(/first)
if status eq 1 then begin
rec=ors->getRecord()
status=ors->moveCursor(/next)
while (status eq 1) do begin
rec=[rec, ors->getRecord()]
status=ors->moveCursor(/next)
end while
endif

Is there a faster way to get all of the records?

My database is on a Sun running Oracle. IDL is on a Win2000 Pro
machine. My response time is better when I'm accessing an Access
database locally. (Duh!) I haven't exported the large Oracle table to
Access yet to do a better comparison.

Thanks.

Report message to a moderator

[Message index]

Dataminer: faster way to get all records in a IDLdbRecordset table?

By: timothy.williams on Wed, 17 September 2003 08:38

Previous Topic:	Co-Linear Contour Points
Next Topic:	Perspective view of a 2-d plot

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 01 06:25:42 PST 2025

Total time taken to generate the page: 1.84450 seconds