| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> if i have a field that is Unique string type.. should i use it has a primary key?
<0> or just make a numberId index
<1> what does "a unique string type" mean to you
<1> that implies more of the datatype, not the value
<0> name that never have two of a kind
<1> which doesn't make sense
<1> that is just unique, not unique "string type" which doesn't make sense
<0> i just wanted to say which type is it..
<0> not int
<1> just because it is unique does not merit it a primary key
<1> all your columns can be unique it has no significance
<0> what has significance?
<0> i guess that if i have main table and child table the connection between them would be faster if i work with NumberID's. if i do a 1 to many connection...
<0> am i right on this, Darken|?
<1> if you work with integers it will be faster yes
<0> indexing with strings would be slower i guess
<1> yes
<0> but sql is fast anyway, would i notice the difference anyway?
<0> msqql
<0> mssql
<1> that depends on many variables
<2> would you notice a difference in int indexing vs string indexing?
<2> depends on the amount of data your indexing ...
<2> and the size of the strings ...
<1> re zoul
<3> hello
<0> strings size max is 5 chars
<0> key string is 5 char max
<1> Raindm here is an excellent way for you to learn
<3> is it possible to perform aan update on a view
<1> make 2 tables with string and int PKs
<1> and analyze the results
<1> you will see how much faster your specific application is
<0> but i guess i'll have to put many rows to notice the difference ...
<2> MasterX: if the view is updateable, sure
<2> to update a view, the dbms needs to know where what to update ...
<2> if the view has joined tables, each joined tables PK has to be selected in the view, so it knows where to put the right data ...
<2> if the view is a single table select, that tables PK must be selected ... so the dbms knows what records to update, etc ...
<4> You should ask these guys about that brilliant CSV in a blob for historical information plan :P
<0> Halo_Four: hehe.. i would have, but it would take long to explain
<0> Halo_Four: i still think that if i handle the binary data in memory (loading from a binary file or blob) i would reach better performance results.. but harder to work with ..of course
<5> anybody got this: Microsoft OLE DB Provider for SQL Server error '80040e07' errormessage before? And know how to fix it?
<4> http://www.aspfaq.com/show.asp?id=2289
<6> halo
<6> have experience with sybase?
<4> nope
<6> i heard sybase = driver problems
<5> i was reading that one
<5> but didnt do me much good
<3> one question
<3> is a sql server databse much faster than ms access
<7> yes
<4> Depends on the use.
<8> wth
<8> this troll is still trolling?
<8> does anybody know anything about PCI Express motherboard and video cards?
<2> Arrakis: what do you want to know about them?
<8> well i'm looking and from what i see most high end mbs have like 1 or 2 pci express
<8> and alot of the lower end give more PCI express slots and actually give you pci (old) slots
<8> just wondering if anybdoy knew what PCI express setup somebody who is used to having dual video card setup - would want to look at
<8> should i look for a mb that has say 2 PCI 16's ? and then get 2 video cards that are PCI 16 compatible?
<8> or w/e
<2> Arrakis: if you want dual pci-e vid cards, you need dual pci-e slots ...
<8> right
<8> and there are setups that go like
<8> 2,
<8> 1, 1, 1
<8> 1, 1
<8> 2, 2
<8> and 1, 1, 1, 3
<8> where they give you 3 old pci slots also
<2> wtf is 1,1,1 ?
<8> PCI-1, pci-16, pci-4
<2> and wtf is 2 and wtf is 3?
<8> usualy tthats pci-1 and pci-16
<2> get a board that has what you need, and what you use ... heh
<8> http://www.newegg.com/Product/ProductList.asp?Submit=ENE&N=2000200280+70001182&Subcategory=280&description=&srchInDesc=&minPrice=&maxPrice=
<2> it's a fairly simple thing to figure out really, heh ;)
<8> yes - but seeing as how
<8> i dont know anything about PCI-expresss
<8> i was hoping there were people out there that knew more about it then what i've delved ;)
<2> do you have a need for any pci-express slots?
<8> I update every 3-4 years
<2> Arrakis: pci-express, pci, agp, isa ... there all just ways of communicating ... ;)
<8> AMD K6 233, P3 750 , AMD XP 1800
<8> my next machine has to be able to last me 2-3 years min
<2> heh, I update every 6-12 months, lol
<8> i seem to never have the money
<2> Arrakis: are you a hard-core gamer ...
<8> i dont even have the money to do this update
<8> nooo
<8> but
<2> pci-express at this point is only really used for video cards, just like AGP ...
<8> http://67.11.202.208:8283/images/leetsetup.jpg
<8> that is my current setup
<8> and I can tell you that the amount of bandwidth to push 3 monitors
<2> agp was originally going to replace PCI all together, but no one saw the point in replacing generic PCI operations with AGP ... as their was no need for anything other then video cards
<8> is a drag on the cpu
<2> PCI Express has the same issue
<8> yeah - i can imagine that PCI express is only good for
<8> video cards and raid cards
<2> so ... based on that knowledge
<2> what do you need ? :)
<8> well i know i'm going to need a minimum of 3 PCI express slots
<8> io just dont know whether Im going to need them to be all the same speed
<2> heh
<8> or whether ill be able to find controlers and cards that run on each one
<2> why not just buy a video card that's dual-headed ...
<2> that takes care of two monitors for you ...
<8> yeah
<2> the third video card, just make it a generic pci card ... and do generic output to it ...
<8> i currentlyhave a dual video card pci
<8> and an agp
<2> or get a nice pci dual-head, and a kick*** pci-e single headed ...
<2> use the kick*** pci-e for gaming and hardcore graphics ..
<2> the other two ... 'fun' ;)
<8> yeah
<8> cause its going to run vista
<8> so its going to need some oomph
<8> and like right now the pci is really limiting on this
<8> all java applications run like ****ing *** when they are running on the pci cards
<8> Radeon X1900XTX
<8> 512MB GDDR3
<8> PCI Express x16
<8> mmmm
<8> i wonder how well ill like having an ati radeon as myprimary video card
<8> hmm
<8> seems like they only have PCI express 16 video cards
<8> hmmph
<8> guess that kind of ties ones hand
<2> heh
<2> pci-express doesn't really seem to have much more power then the latest and greatest agp cards .. lol
<8> i knew it was going to be hell i was just hoping by now
<8> it had stabilized
<8> its the 2nd video card that i'm most worried about
<8> plus the move to Windows Vista
<2> get a board with AGP and PCI-Express ... ;)
<2> have one PCI-Express ... and one AGP ... make em both dual head ... and you can have 4-displays ;)
<2> most of the higher end cards are dual head by default anyhow ...
<8> i dont think any of the agp mbs have pci express
<2> but they usually cost about $350-500 for a decent card, if you want something that'll last you another 3-4 years
<8> oh wiat
<8> here we go
<8> heres one
<8> well heres what is scaring me lol
<8> all of the mbs i see that have the options i need are going for 50 - 90 bucks
<8> :-/
<2> I usually spend about $1500 every 6-9 months ... on new parts ...
<2> recycle anything that's recyclable ... and replace anything that's out-dated
<2> a $50-90 motherboard is cheap ;)
<2> mine usually cost me $150-200 ;)
Return to
#sql
or
Go to some related
logs:
#stocks
#computers
#nhl
#computers
#goal
#sunos
#beginner
fentaynl patch
#politics
gentoo the drive appears confused
|
|
