Hi Mark,
Doing selects in a loop is never a good idea especially on large files
and definitely not a sorted one like you are trying to do.
But if you really have no other option, then you should at least create
an index on ItmID on TABLE2.
I don't know about Universe, but don't you have to do
...@listserver.u2ug.org] On Behalf Of Mark Smith
Sent: Wednesday, April 01, 2009 10:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Question about indexing
Hello everyone,
I have a question about indexing. I have just a little of experience, so
be patient with me.:)
First of all I'm using Universe 10.0.4.0
: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mark Smith
Sent: Wednesday, April 01, 2009 10:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Question about indexing
Hello everyone,
I have a question about indexing. I have just a little of experience
Mark,
READNEXT works on any multi-attributed array not just on active select
lists.
Look up the FROM option or the SELECT command in the Unibasic manual.
And of course instead of reading from the SAVEDLISTS file you might
rather want to execute 'get-list listname'
I gathered that the
Hello everyone,
I have a question about indexing. I have just a little of experience,
so be patient with me.:)
First of all I'm using Universe 10.0.4.0 and SB 5.2 on a Windows 2003
Server on a Dual-Core Opteron Server and 4Gb of RAM SCSI drives
I wanted to simplify (just a little) my