RE: [U2] UV 10.1.2 bug
Sounds like the kind of thing that would happen if the file had a lot of overflow. Or a very badly designed index, or trigger. Any of those possible? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
quote who=Brian Leach Sounds like the kind of thing that would happen if the file had a lot of overflow. Or a very badly designed index, or trigger. Any of those possible? Brian We don't have any triggers on those files. There are no indexes on one of the files and the other one has 5 indexes. Come to think of it, I've not tested the file with no indexes because they became corrupt a few days ago and I removed all of them and forgot to re-add them over the weekend. I'll have to check the process on that file again and see what happens without the indexes. Karl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior before, however, and am still perplexed. Karl quote who=[EMAIL PROTECTED] quote who=Brian Leach Sounds like the kind of thing that would happen if the file had a lot of overflow. Or a very badly designed index, or trigger. Any of those possible? Brian We don't have any triggers on those files. There are no indexes on one of the files and the other one has 5 indexes. Come to think of it, I've not tested the file with no indexes because they became corrupt a few days ago and I removed all of them and forgot to re-add them over the weekend. I'll have to check the process on that file again and see what happens without the indexes. Karl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.2 bug
I've seen this kind of thing when an index of a sparsely populated field was created without the NO.NULLS option. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ [EMAIL PROTECTED] wrote: Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior before, however, and am still perplexed. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Karl This sounds like an index overload issue - check NO.NULLS and for overloads. I have seen similar problems with extreme overload on a file with 99%+ of all the records with the same key (and yes - it was NULL). If there is stuff you do NOT want to index and it is not NULL then consider a virtual to return NULL (string) if it is not something you are interested in and use NO.NULLS. Indexes help on equalities and ranges - not on inequalities and pattern matches (unless you create virtuals and index the result of the virtual e.g. IF A matches 1N0N3A4X'.' THEN 1 ELSE 0 (though this is a bad example with a Boolean result). Remember also that indexes should not be used with external lookups (e.g. TRANSlates) - I;m sure we've all been there one time or another - not a good idea unless the data is static (no - REALLY static). Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 18 January 2005 19:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV 10.1.2 bug Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior before, however, and am still perplexed. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV 10.1.2 bug
I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Sounds like the kind of thing that would happen if the file had a lot of overflow. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
quote who=Ed Clark Sounds like the kind of thing that would happen if the file had a lot of overflow. That's what I would have thought, too. However, I'm seeing this on files that have recently been resized to about 10% larger than current need for growth. AND they aren't that big. 30,000 items in one case; 418,000 in another. Karl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Could they be hashing very badly? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 2:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV 10.1.2 bug quote who=Ed Clark Sounds like the kind of thing that would happen if the file had a lot of overflow. That's what I would have thought, too. However, I'm seeing this on files that have recently been resized to about 10% larger than current need for growth. AND they aren't that big. 30,000 items in one case; 418,000 in another. Karl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Definitely looks like overflow - what does an ANALYZE.FILE tell you? --- also what is the physical file structure (O.S level files and sizes). One other possibility - is there a horrendously large indexed entry (like 10's of K multivalues or similar) ? - let's take a look at LIST.INDEX ALL DETAIL. and a check on triggers wouldn't hurt either. Regards JayJay I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/