i'm learning... and it's called work...

build a page, to show records filtered with "data status date"

the caveats:

-there would be 5k+ records to show.

-the data is sitting on single database with 2k+ tables,

tables are prefixed w/ application name i.e "INVENTORY_*", "PAYROLL_*".

-there are 20+ applications that'd be accessing the db at any point in time.

-some of the 20+ apps have a normalized table structure & some have not.

-app and db are sitting on one machine & it's a P3, vintage servers

the solution:

-use sql paging, to show specified number of records per page; basically split the data into subsets.

-recomend more specific filter options i.e. field range, dept, item category, etc.

-use indexes on queries.

on the solution part, item 3 is within our control... we can do this easily but the first 2 items are the catch. the stakeholder wants to be able to view all the data as filtered only by the data status date. no other filters would be created. does not want to do a paging function coz, it's better to scroll down rather then click thru the page numbers. would also need to edit a selected row within the page's tabular data presentation. and requires it to be fast. this requirement would work well on a desktop app, it's a challenge if it were a web app...

i do believe that the paging solution plus the additional filter options would really be able to aleviate the perfomance issue here, i've recomemded this approach over and over again and i'm still recomending this (else, i won't be blogging about this).

this are one of the things i do... i'm learning... and it's called work...

caught with a thought

there have been so many times that these fleeting thoughts catches me; and in my mind, i have them written.

but these fleeting thought are just what they are... fleeting. by the time; i want to write them, they have come and passed.

try as i can to recall them, when they are written; they just are not the same as the first intance of that thought.

i guess the saying "hold that thought" is far from applicable at this point.

have you ever had these?

has it ever occured to you that at any given point in time, you may have written a book-worth of jibbering?

these random mind-jibber that despite a hectic, stressfull, weary day; is still able to creep in and give you the benefit of self-reflection or whatchamacallit.

'tis not like i cannot write, i'd admit 'tis more of not being in the zone to write something.

they often pop up when i'm in the middle of doing something else, either at work writing code or on some chores.

rare are those days, when i can sit over coffee and think what to write; never those days even. only an ernest hemingway would have those.

The DBA's Demise

excerpted from an e-book: "Confession of an IT Manager", this is a funny poem but I do find this too close for comfort. I was here before, I am no DBA but this is relatable to every aspect of what I love to do for a living...

From your face I can see

that you work in IT

what has brought you to this sorry state?"

This poor wretched geek

then started to speak

and told me his terrible fate

Cruel fortune had picked him,

as sad deadlock victim.

The conflict had left him for dead;

for wise men don't mess

with a deadlocked process

an incident DBAs dread.

"When I'm dead, on my harp

I shall play in C#"

on my terminal, happy I'll be.

I'm going offline

to a site that's divine

where all pizza and coffee is free."

"Insert into grave

select * from poor Dave

And put on my gravestone 'Raiserror!

a victim, one time

of a deadlocking crime"

Then he died with a look of sheer terror.

I think I'm gonna like reading this book... i'll read along and see if there're anything else worth sharing, or perhaps I'll share this book soon