Recent content by Grant Holman

Hi, its was just a hypothetical, not a real world requirement. Interested to hear that as soon as you range match the rest of the index becomes irrelevant, don't think I properly appreciated that.

Thanks both for your replies.

Is it possible to NOT a CONTAINS clause on a WORD-INDEX? e.g. where field contains 'cat' but NOT 'dog' Thanks

It would be doing range matching on field A, so choice 2 then. Thanks.

Hypothetical: Table X has 4 char fields A,B,C and D. I need to index on A + B + C and A + B + D. What are the appropriate indexes to create for the table: Choice 1: Index 1 A + B Index 2 C Index 3 D Choice 2: Index 1 A + B + C Index 2 A + B + D I'm thinking Choice 1 as Progress will...

Tom / Cringer In complete agreement with you both. There a good few pretty sizable operations still sitting on V9 and earlier in the UK.

It runs on Windows Server 2003. In my experience: Companies feel they need to 'move with the times' and consequently hold off upgrading Progress on the basis that at some point in the near future they will be on a completely different platform anyway. (This misses the point that Progress is...

Quite a tough sell when the system runs one of the largest retail operations the UK with close to 3,000 retail outlets :-)

Hi Tom, I quite agree about v9 being ancient history, however I'm just a hired hand and have to work with what I have! Thanks for confirming my suspicions. Cheers Gramt

Hi, Promon's buffer hit ratio field can be calculated using the _actbuffer VST table as follows: (_buffer-logicrds - _buffer-osrds) / _buffer-logicrds * 100 The fields are integers therefore limited to approx 2,147,000,000 at which point they start counting back down. This continues up and...

running 'tabanalys' on a db shows the following: 779269 empty block(s) found in the database. 1030524 total blocks found in the database. Progress says that a 'idxbuild' may need to create a .srt file around 75% of the 'database size' when rebuilding all indexes. I need to be certain how big...

Which of these is setup is 'best'? 1) Having the webspeeb agents, the web server and the db server all on the same box. 2) Splitting these over more than one box. For example, having the web server on its own box and the agents and db server on another. I've seen both of these examples...

If: page 1 has values A,B,C page 2 has values C,D,E page 3 has values E,F,G 1, 2 and 3 can call page 4 which will return back to the calling page. At present I would hard-code into page 4 HIDDEN fields for A,B,C,D,E,F and G as these are all potential entries that could be passed into 4 and...

Thanks for your helpful reply. Why do I use it? I know Apache, I don't know IIS, Apache is the most widely used WebServer in the world (approx 65% of all web servers are Apache).

Should Apache 2.0.45 work with Progress 9.1D on Windows? I get a 'Not Found' page returned when I try 'http://localhost/htdocs/cgiip.exe/WService=wsbroker1/webutil/ping.r'. Apache is definitely running OK and the Agents are running OK.