page contents Not so fast! – The News Headline
Home / Tech News / Not so fast!

Not so fast!

Pilot fish who is a pc science professor will get a choice from a former pupil stumped via a database downside — person who will have to be beautiful simple to resolve.

“This was once no longer considered one of my maximum stellar scholars,” fish admits. “It kind of feels that they had arrange a database for a brand new state company and the machine was once operating very slowly.

“I did a small quantity of consulting at the facet, so I agreed to have a look.”

Seems the database is relatively surprisingly arranged. The reason? Former pupil tells fish it is arrange for ease of knowledge access.

And for retrieval? “No downside,” former pupil says. “We created an index for each box so you’ll be able to glance up anything else briefly. We even created Soundex codes for each final title, and created an index for the Soundex codes too.”

Then what is the downside? fish asks.

“First we arrange the schema, then we created all of the indices and the whole thing was once positive,” ex-student says. “Now, after we begin to load exact information into the database a document at a time, the machine is amazingly gradual.”

Fish already is aware of the solution: The whole lot is slowing to a move slowly as a result of all the ones loads of indexes are being up to date as every document is being loaded. The most obvious answer: Drop the indexes, load all of the information without delay, then re-create the indexes.

Sure, I feel I will be able to remedy the issue in no time at little or no price, fish tells the ex-student. I will be able to write a pleasant formal record about what to do.

And that’s the reason the tip of it, proper? Smartly, no.

“Being a state company, they wanted a proper contract,” says fish. “And the contract needed to be authorized via the state IT division. However the state IT division’s other people sought after the trade for themselves as a substitute of giving the paintings to me.

“So I by no means did inform my former pupil how easy it was once to mend his downside.”

Were given forms? Inform Sharky about it. Ship me your true story of IT lifestyles at sharky@computerworld.com. You can rating a pointy Shark blouse if I take advantage of it. Touch upon these days’s story at Sharky’s Google+ group, and browse hundreds of significant outdated stories within the Sharkives.

Get Sharky’s outtakes from the IT Theater of the Absurd delivered immediately in your Inbox. Subscribe now to the Day-to-day Shark Publication.

About thenewsheadline

Check Also

1539815212 whats up with the razer phone 2 technically speaking - What's up with the Razer Phone 2? — Technically Speaking

What's up with the Razer Phone 2? — Technically Speaking

Tech newshounds Jake Krol and Matt Binder communicate Techtober and the Razer Telephone 2. Learn …

Leave a Reply

Your email address will not be published. Required fields are marked *