Jump to content


Photo
- - - - -

Sql and Like


18 replies to this topic

#16 Rob Donovan

Rob Donovan

    rob@proivrc.com

  • Admin
  • 1,640 posts
  • Gender:Male
  • Location:Spain

Posted 31 January 2006 - 02:45 PM

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.

#17 Chris Pepper

Chris Pepper

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 369 posts
  • 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

Rob Donovan

    rob@proivrc.com

  • Admin
  • 1,640 posts
  • 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.

#19 Chris Pepper

Chris Pepper

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 369 posts
  • Gender:Male
  • Location:United Kingdom

Posted 31 January 2006 - 08:43 PM

Hmmmm.... I'm still completely stressed out over this upgrade.

Maybe you could set a flag to disallow any posting from me for the next couple of weeks!!!!!!! :)



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users