Hi,
If you use any of the SEL commands, ProIV will still issue a SELECT statement based on the fields that you use, rather than all the fields.
I would use the SEL command unless you are doing something specific in the SQL to reduce the record set, as it simplifies the code.
Rob.
Click the link below to see the new game I'm developing!
Sql and Like
Started by
Marco.Bega
, Jan 30 2006 05:08 PM
18 replies to this topic
#16
Rob Donovan
-
- Admin
-
- 1,652 posts
rob@proivrc.com
- Gender:Male
- Location:Spain
Posted 31 January 2006 - 02:45 PM
#17
Chris Pepper
-
- Members
-
- 369 posts
ProIV Guru
- Gender:Male
- Location:United Kingdom
Posted 31 January 2006 - 06:12 PM
Some places loop through looking at all Bal arrays, while some updates just use say BAL(9)...
Couldn't you use two different ProIV File Definitions with an Alternate to the same table to optimise this?
You have one defined as an array, the other with named fields and use the ALTERNATE name to map them on to the fields.
#18
Rob Donovan
-
- Admin
-
- 1,652 posts
rob@proivrc.com
- Gender:Male
- Location:Spain
Posted 31 January 2006 - 06:18 PM
Hi,
As I mentioned above, that is what I made the system do...
It was amazing the speed improvement we got
Rob.
As I mentioned above, that is what I made the system do...
It was amazing the speed improvement we got
Rob.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
