Oninit cdi / Archive
Talk to an expert →

Re: Not a Benchmark... but sort of...

Posted in 2008

Topics: Performance & Tuning, Data Types & Schema Design

Ian Michael Gumby — — source: Usenet: comp.databases.informix

On Oct 12, 11:01 am, Obnoxio The Clown <obno...@serendipita.com> wrote: > >> I am especially pleased that your benchmark does not include deletes, > >> which are a bit sucky in TS. > > > Huh? > > > TimeSeries data types aren't usually deleted unless you want to delete > > the entire series. > > Usually. Please note that word. > That's like saying "don't use a vw bug to tow a semi-trailer." Yes it can be done, but the vw bug wasn't designed to pull semi-trailers. The point is that you don't use TS if you want performance on deletes. Its not what they were designed for. They were designed for data capture. Know the advantages and limitation of what tools you are working with.

↪ replying to Ian Michael Gumby
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Ian Michael Gumby wrote: > On Oct 12, 11:01 am, Obnoxio The Clown <obno...@serendipita.com> > wrote: > > >>>> I am especially pleased that your benchmark does not include deletes, >>>> which are a bit sucky in TS. >>>> >>> Huh? >>> >>> TimeSeries data types aren't usually deleted unless you want to delete >>> the entire series. >>> >> Usually. Please note that word. >> >> > > That's like saying "don't use a vw bug to tow a semi-trailer." Yes it > can be done, but the vw bug wasn't designed to pull semi-trailers. > The point is that you don't use TS if you want performance on deletes. > Its not what they were designed for. They were designed for data > capture. > > Know the advantages and limitation of what tools you are working with. > Jesus H. Christ. You are a woman and I claim my five earbends. -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com

↪ replying to Obnoxio The Clown
Ian Michael Gumby — — source: Usenet: comp.databases.informix

On Oct 12, 3:53 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > > Know the advantages and limitation of what tools you are working with. > > Jesus H. Christ. You are a woman and I claim my five earbends. > > -- Naw. You're just a silly git. I could have said it was like trying to take down an elk with a .223 varmit rifle. Its possible, but never a good idea. Or I could have said something like trying to do open heart surgery using a bowie knife instead of a scalpel. Is that manly enough for you?

Glossary