Search results

If I have a rowid but don't know the table it relates to, is there any way to locate the record and then identify the table? Other than doing this: def var bh as handle. def var fnd as logi. def var rwid as rowid. rwid = <a valid rowid>. for each _file no-lock where...

Thanks for the quick response Rob. :o I had just found the answer myself and was about the post a please ignore.

Can someone tell me how to determine which index on a table is the Primary one by reading the meta-schema. Everything else I need is there e.g. _Index-Name, _Unique, _idx-num, etc but I can't for the life of me figure out where to fine the Primary indicator. Thanks in advance.

I agree in the perfect world however in the real world there are other aspects to consider, one being the $30,000 cost to upgrade WG to Enterprise. Another is that we already have some members of our board pushing for a move away from Progress to a more 'mainstream' development platform (read...

Did you get anywhere with this issue as we have the exact same problem with a Workgroup DB, sluggish performance and the server seemingly twiddling it's thumbs. The only difference is we're in OE10. Would be keen to hear if you've found any solution?

Some initial performance monitoring results: Promon shows Buffer Hits in the 99-100% range. Never drops below 98%. Windows Performance Monitor on DB Server Disks 99% idle Processors max out at 19.5% Physical Disks Current Queue Length 0. Does not seem to move from 0. VMWare Performance...

F: data extents I: index extents As you can see the processors are hardly ticking over... c:\temp Yes Huge difference. On client's machine is usually at least twice as fast as the same job on the server.

Thanks for the great advice, quite a bit to check out but as you say, enough to get started! Thanks again, I will report back on results.

Tom, thanks for the advice, could we contract your services remotely to investigate this in detail and provide us a recommended resolution path going forward. Note quite as good as being here in NZ in person, though frankly you wouldn't want to be here at the moment anyway as the summer weather...

We have been experiencing rather lack lustre performance over the past year or so since upgrading our server. During some recent research on Progress Talk I noticed an article pointing out the running the DB in a Raid config is pretty much the worst thing you can do for performance and...

Perfect, just what I needed. Thanks Rob ;)

Hi all I have used the "for each _file , each _field of _file" to retrieve field names from dbs many times in the past but have now struck a small problem that has me scratching my head... The "for each _file" returns tables in the current working database only so the question is, if I have...

Hi all, we have been a Progress shop since Version 3 so are well versed in the ways of PSC. We have had a recent request to build a number crunching system that needs to cater for up to a 100,000,000,000 (yes 100 million) transactions per annum. Can't tell you anymore at this stage but let's...

Having been a Progress house since 1986 we are now wanting to offer internet access to our application. We have prototyped a portal using WebSpeed and sent it to a security consulting firm for review and penetration testing. Their findings indicate that WebSpeed fails on 5 our of the 10 key...

Thanks RHD, will take a look at your suggestion.

Thanks Tom but table-references is not available in V9...

I need to extract the names of tables referenced in either .r or .p/.w code. Does anyone know how to do this in V9? Cheers

CONNECT db1 <start up parameters>. CONNECT db2 <start up parameters>. FOR EACH db1.customer: FIND db2.customer WHERE db2.customer.id = db1.customer.id NO-ERROR. IF NOT AVAILABLE db2.customer THEN CREATE db2.customer. BUFFER-COPY db1.customer TO db2.customer. END.

Not sure about the code page issue but connecting to 2 dbs: CONNECT db1 <start up parameters>. CONNECT db2 <start up parameters>. FOR EACH db1.customer: END.

Thanks Tony/Jason, this is fantastic help. I will try it out as soon as have upgraded from 9.1E to OE10!! I will post another message when this has been done. Thanks again!!