| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> now i gotta figure out composite index, clustered index, and a god damn index
<1> for sql databases, i prefer GiST indexes
<2> clustered indexes control the way in the physcal table is ordered.
<2> composite indexes are indexes on more than one column
<0> One advantage of GiST is that it allows the development of custom data types with the appropriate access methods, by an expert in the domain of the data type, rather than a database expert. o0.
<2> God damned indexes are indexes that seem to not be working right.
<0> well, Drk`Angel. I just want fields like Surname, Email address, Town to be searched fast.
<0> so when I do a SELECT WHERE it's fast.
<0> but i can't think how it works on multiple fields
<0> is it when I do a SELECT WHERE ( ) ( ) on 2 fields? that's where it's faster than having single index per field?
<0> someone should tell me to RTFM
<1> an index on multiple fields isn't only for searching, but for grouping as well
<1> for example, our lists weren't just ListId + ContactId
<2> TByte: Three individual indexes would probably be best.
<1> ListId + OrderId + ContactId, with an Index on ListId + OrderId, this allowed us multiple contacts on the same list, also allowing us to preserve an order to it
<2> composite indexes are only useful if you always search on all of the fields in it, or the leftmost fields.
<2> So, if you have a composite index on (Surname, email, town), and search just on email or town, the index won't be used.
<2> If you search on surname, or surname and town, or all three, it will be.
<2> Since clustered indexes control the physical ordering of the table, you can only have one per table.
<2> So, don't waste it. :)
<0> thanks, im digesting it.
<0> so on composite indexes, if I dont search the leftmost field, it wont use the index at all?
<2> Nope.
<0> since the tree is using 1 main index to find the OTHER fields, correct?
<0> erm that was rubbish english btw
<2> Just imagine that its a trie stored as a concated string, from left to right.
<2> That's not exactly right, but it makes the way it works make sense.
<0> yes I know how trees work, I wrote a binary tree, so im getting it
<0> so (Surname, email, town) ... if I search by surname, it would find me email and town.... if I use email or town to search index not used...
<0> but if I make an index to (Surname, email, town), i shouldn't really make an index on surname alone, cause it's there, right?
<2> Right.
<2> That would be silly.
<0> I ***ume an index would always contain the row id anyway hm.
<2> Avoid overindexing. Indexes slow down updates, to make retrieval faster.
<0> i didn't think it would be an issue to overindex, but now i can forsee a lot of updates
<0> does it make sense, if you really have **** loads of updates, to turn indexing off?
<0> temprorarily that is.
<2> If you're doing a giagantic batch update, sometimes.
<2> Just have to remeber that when you turn indexing back on you'll have to wait for them to catch up
<0> I can see that being only a slight improvement
<0> at the end of teh day it would index it the same way in batch or not
<2> Depends on how big the update is.
<2> And how many indexes you have.
<2> Usually only makes the most sense for data warehouses.
<2> (Scads of data and indexes)
<3> yah
<3> but firebird is a bit slow on inserting with indexes
<0> I should just make individual indexes for now, then basd on myqueries, decide when to compose indexes
<0> Oh Mithandir my man :P
<2> TByte: Yes.
<2> Depending on how much data you have, and how selective a column is, sometimes it makes the most sense to just not have an index.
<2> They don't always makes things faster. ;)
<2> Its a lot to absorb all at once. You'll get it eventyally as you run into stuff.
<2> Anyways, gone for now.
<2> bbl.
<0> thx for input
<0> really getting it now
<0> forgot what I wanted to ask Mithandir FB specific :P i need sleep
<0> bbl too, thanks Rahly
<0> gn
<4> Vibes^: That's for sure.
<5> :)
<5> SirPsycho: I thought you'd given up evilsoft.com
<4> You need to read that RIGHT NOW.
<4> Nope, I've had it for ages.
<4> I refuse to part with it.
<5> Woah... blast from the past.
<4> Exactly.
<5> Pete, Cott, and the gang.
<4> I found it looking for a copy of my resume for a side job.
<5> Good grief... what year is this? 1996?
<4> I'm not actually sure. The file date is 1/12/2000, but I think it's older than that.
<4> I think that's when I copied it off my previous computer.
<5> Well, they were still making references to Fredster, Robyn, and scratchme.
<5> So it's pre-2000, as I believe all three of them stopped appearing right around the time I moved to Illinois.
<4> Right, and I worked at SalesLogix from mid-1998 to mid-2001.
<4> So it could have been any time in that range.
<5> Yeah
<5> I'm looking for a hint as to what I might have been working on to give us a clue.
<4> I had a big laugh at the part where you complained about not being made fun of as much as everyone else. :)
<5> Hmmm... I was opped, so it wouldn't have been as early as '96... Not sure when that first happened though.
<5> SirPsycho: Yeah, I laughed at that too...
<5> Hmm... no clue as to the date there.
<5> ACtually, I'm guessing spring of 1999.
<4> Well, I still had an account with Primenet then, and I don't know when they got bought out by Global Crossing.
<4> Why then?
<5> Since woop made fun of my by saying "linux this linux that," it was probably when I was on my one and only "open source is good" kick.
<5> Which basically ended when I started having my own bills to pay. :)
<5> So it basically encomp***ed my freshman year of college... Actually right around the time you and I first met.
<4> It's certainly possible.
<4> As I said, I know it had to be after July 1998, because I didn't work at SalesLogix before then.
<4> I'm looking at the other files that were with it for clues to try to guess when it actually was.
<5> And summer/fall 1999 was when you and I made a half-hearted attempt to do some work together.
<4> Right.
<4> However, SalesLogix screwed it all up by making me work lots of overtime.
<5> And the fact that we knew I was leaving relatively soon didn't help either...
<5> It's a shame though, because it has turned into a successful business.
<5> Just not run by us. :P
<4> Yeah, it's basically Froogle.
<4> When were you gone in Russia?
<5> May 2000 - May 2002.
<5> So we can definitely pin it between summer 1998 and may 2002.
<5> Actually, it would have to have been after august 15, 1998, because I was on tour from may to august of that year, and I think you started working at slgx during that.
<4> Yes, I started a couple days before our birthdays in 1998.
<4> And I got laid off from SalesLogix in early May of 2001.
<5> The only project clue is my exasperation over a fatal exception #6 right at the beginning.
<5> I wonder what that would have been....
<4> Well, the first link on Google for "fatal error 06" is to a Microsoft page about an error installing Windows 98.
<5> I googled for "fatal exception 6" and got a bunch of linux kernel discussions.
<4> Hmmm... I'm trying to make sense of the "TheBoship" comment about leaving the company.
<5> It's not Pete
<5> First line.
<4> I know.
<5> Oh, I see.
<5> ...Historical reference to what.
<4> But Pete worked at SalesLogix, then quit and went to WebLogix shortly after I started there.
<5> When did Pete leave SLGX for the whole weblogix/vstore company?
<4> Then, WebLogix got new management, and Pete didn't like them, so he quit.
<4> (at least I think that's what happened)
<5> Woah... I just checked out vstore.com, and they're still in business.
<5> I thought weblogix suddenly had a better idea that became vstore.
<4> Yes, they are, although they don't do the same stuff they did when I (very briefly) worked there.
<5> Looks similar to what they demoed when I went up there.
<4> I tried talking them into doing something more like they're doing now, but Dan wasn't interested in listening to anyone's ideas but his own.
<5> "open your own store! we do the fulfillment!"
<4> They do that still, but they cater to larger organizations now.
<5> oh
<4> I seem to recall that they do a lot with a certain Christian organization whose name eludes me at the moment.
<4> I'm sure they'd be thrilled to know that WebLogix used to be a porn site.
<5> ahaha
<5> weblogix.com just has a for sale notice on it.
<6> why does SalesLogix sound so familiar?
<4> I actually interviewed at WebLogix twice. The first time, they told me that they were working on some new "video streaming technology", which was apparently code for running a porn site.
<4> cmf: I don't know. I worked there for about three years, and TheBishop worked there for a while before that, so maybe you remember it from us mentioning it here?
<6> ah yes.. didnt TheBishop own it?
<6> i applied there when I was 15
<6> i remember now heh
<5> He didn't own it, he was just an employee.
<6> really?
<4> No, not exactly, though he did get a fair amount of stock from them.
<5> (A significant one, but still not an owner)
<4> He was one of the people who helped start it.
<7> later gents
<4> He sold back his shares to the company when he quit for quite a bit less than he would have received if he had waited a year or less until the IPO.
<4> This line made me crack up laughing: (@pgmillird) I climbed the gravel in my patio.
<5> pgmillard RIP
<6> :(
<4> Indeed.
Return to
#delphi
or
Go to some related
logs:
#photoshop
Background badtzmaru
deago ff11
#windowsxp
dts copy sql objects keep null values
hp recovery partition disc
#gentoo
#hardware
tcl list element in braces followed by
#computers
|
|