Bill, I agree with you that I would think that an index on a TEXT would be slower than an INTEGER (although the difference may neglgible). I'm still snooping around to see if I can see anything of interest in the database. I thought of recreating the index but the database is RELOADed every morning before we get to work.
Jan -----Original Message----- From: "Bill Eyring" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 12 Aug 2009 17:59:29 -0400 Subject: [RBASE-L] - RE: Index issue Jan, To my way of thinking, a lookup on a 12 character text field should be slower than a lookup on an integer field(assuming both are indexed). If I am correct, then, if my text lookup and delete is fast, an integer lookup and delete should be faster. Any engine gurus have any thoughts on this ? Bill Eyring From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, August 12, 2009 4:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Index issue Bill, Hmmm. Never thought of looking for a view that might affect speed. I will have to look when I return to the office. My indexed column is an INTEGER so I'm not sure if there is the difference. Jan -----Original Message----- From: "Bill Eyring" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 12 Aug 2009 16:16:06 -0400 Subject: [RBASE-L] - RE: Index issue Hi Jan, I have an 8.0 database with one table that has almost 800,000 rows containing 9 columns. The column I used for testing is a text 12 column with an index on it. The column is not unique and has rows containing duplicate values. The value for the column which I tested had 8 rows in the 800,000 row table. For Release 0420 the edit and delete were almost instant. --EDIT ALL FRO TABLENAME WHE COLNAME='XXXXXXXXXXXX' --DEL ROWS FRO TABLENAME WHE COLNAME='XXXXXXXXXXXX' For Release 0703 the edit was almost instant with the delete taking a beat longer than 0420, about 1 second. I did not see the long delay that you saw. Is it possible you have a view based on your table ? If so, I would try rebuilding the view. Hope this helps. Bill Eyring From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, August 12, 2009 11:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Index issue Group, Running Turbo V8. Was just reported to me that certain functions appear 'slower'. In this particular case it is a record modification routine. It is rudimentary in that it deletes the row in question and then rebuilds it. The row is indexed but I cannot use a PK on this because it is allowed to have duplicates (albeit not a frequent occurance). The lookup of the row is fast. EDIT ALL FROM mytable WHERE RowID = .vRowID However this takes about 15 seconds to accomplish. DELETE ROWS FROM mytable WHERE RowID = .vRowID The test was run on a local machine so that network influences would not be a factor. I don't consider this a large table (around 500k). Since I run with STATICDB ON I don't think I can do DROP INDEX ON mytable DELETE ROWS FROM mytable WHERE RowID = .vRowID CREATE INDEX indexname ON mytable (RowID) As I look back this has only occurred since the 0701 update on V8. But I really hesitate to call this a problem. Has any else noticed anything like this on large tables (or would you be willing to try it)? Thanks in advance. Jan -----Original Message----- From: "Bill Eyring" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 11 Aug 2009 18:59:54 -0400 Subject: [RBASE-L] - RE: Sub-Report Question Emmitt, I don't need the sub-reports side by side. I need one each on the 2nd and third part of a 3 part check. My application has to provide 30 lines of detail for each subreport. The way I thought I could accomplish this was to put a sub-report on the 2nd part and a sub-report on the 3rd part. Each subreport was setup for 2 columns so I could fit these details in a space approximately 3" high by 7" wide. Each sub-report works off the same table and contains identical information. So far, the 2nd subreport wraps to the top of the 2nd column as expected, but the 1st subreport stops at the end of the 1st column and will not wrap to the top of the second column. I need both subreports to print exactly the same for the space available. Thanks for the idea. I'll keep on truckin. Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Tuesday, August 11, 2009 5:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sub-Report Question Bill, Have you tried a sub-report inside a sub-report approach to get them side-by-side? Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Tuesday, August 11, 2009 4:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sub-Report Question Tom, I had done just that last night. Both regions are set to stretch. The 2nd region wraps to the 2nd column as expected. However the 1st region goes to the end of the first column and does not wrap to the 2nd column. I tried setting stretch off and expanding the subreport height to the full height in 1st region with the same incorrect results. Maybe Buddy is right that the 1st sub-report will push down into the 2nd sub-report. Time for my thinking cap. Thanks. Bill Eyring -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tom Frederick Sent: Tuesday, August 11, 2009 9:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sub-Report Question Bill, Can you put a sub inside a region, then place the regions where you want them, and let them stretch? Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 O - 217-245-9504 F- 217-245-2350 Email - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Monday, August 10, 2009 6:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Sub-Report Question I have a report (3 part check) where I need to put the same sub-report (subReport1 and SubReport2) in the 2nd part of the check and the 3rd part of the check. Each sub-report is set to print 2 columns each 3.88" wide. The purpose is to wrap the remittance advice line items when they reach the bottom of each check part so I get 2 columns of remittance items. I can get the 2nd subreport to wrap but can't get the 1st subreport to wrap, it just pushed the 2nd subreport down further. Any ideas of how I can fix this ? Thanks in advance. Bill Eyring
