>>>>Hi Nicholas,
>>>>
>>>>>BTW I just checked. One table in this system has 59 indexes.
>>>>
>>>>The project I'm working on had close to 100 in one table before we started optimizing them away. <g> The number of indexed affected the time it took to run the form, because every tag results in a 4 KB block that needs to be read when the table is opened for the first time.
>>>
>>>
>>>Yes
>>>
>>>if my budget was open there would be plenty of work. Unfortunately its not and I've seen several examples of my correcting something at point A causing something to fall off at point B. :-(
>>
>>
http://ndragan.com/pv/captain.html>
>The real problem is it begins to distort your mind and you go "native"
I'm living with that problem for years.
Oh, you mean programming-wise... yep, it's a two-edged sword. On one side, you want to understand what your predecessors were doing. On the other, if that was so good, you wouldn't be cleaning after them. Tricky; you need to keep perspective all the time.
I once had a project like that in front of me, and was very adamant on how long will it take and cost - no easy way out of hand woven say/gets. The customer was seriously convinced it was a matter of a few days to spruce it up - where nothing short of full rewrite would save the app.