146 reputation
4
bio website
location Idaho Falls, ID
age 30
visits member for 2 years, 1 month
seen May 27 at 7:17

Programming: An industry where you have to design your own tools before you can use them, and other people can redesign them for you after you've put them into use.


Jul
30
revised Minimizing Page Fetches
Some additional content to the question.
Jul
30
comment Minimizing Page Fetches
@a_horse_with_no_name - Firebird 2.5.
Jul
30
comment Minimizing Page Fetches
Do you know if that holds true if there are multiple sub-queries per record that comes out of table1? I have some situations where Records in Table1 have to have a column checked against five or six other tables. I'm half-wondering if I've got a circular dependency somewhere or something else amiss. During monitoring I've seen instances where a procedure will retrieve a million+ pages, which seems wrong to me, considering I have ~ 500 rows in one table, and maybe a couple hundred in another.
Jul
30
comment Minimizing Page Fetches
I should point out that I'm testing both, but having wildly errant behaviors at times depending on the cross-sections of my data. IE, if Table1 has many rows I sometimes see huge numbers of page reads, but other times (especially after validating indices) it seems fine. Other times, large numbers of rows in Table2 causes spikes in activity or execution time. I'm looking for a best practice to try to minimize the overhead I'm experiencing that's less dependent on row distribution between the tables.
Jul
30
asked Minimizing Page Fetches
Jun
26
comment Minimizing Indexed Reads with Complex Criteria
Yes, it's declared as BIGINT NOT NULL.
Sep
25
comment Minimizing Indexed Reads with Complex Criteria
@ypercube - No, I'm not certain that's where the performance degradation is. That's why my question was "do I need to be concerned with this, or is it normal behavior of an index?". It's something I noticed while monitoring the database, and I considered it unexpected. I would not expect it to continue to scan the preceding rows when I provide a where clause against an indexed column. FWIW, modifying the index to include ticket_id actually performed worse than just having Status indexed.
Sep
25
revised Minimizing Indexed Reads with Complex Criteria
To encompass comments.
Sep
24
awarded  Custodian
Sep
24
awarded  Editor
Sep
24
reviewed Approve suggested edit on Minimizing Indexed Reads with Complex Criteria
Sep
24
revised Minimizing Indexed Reads with Complex Criteria
Better title. The example code isn't really that complicated.
Sep
24
awarded  Student
Sep
24
asked Minimizing Indexed Reads with Complex Criteria
Sep
24
awarded  Autobiographer