'Bring On The Night'
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
using short meaningless keys makes your appliation run faster and in general is cleaner
I think that depends on what you're trying to achieve and what you're trying to achieve it with. We have just had a vendor in telling us to lengthen our keys (as in, number of fields) for better performance, so there you go.
We have just had a vendor in telling us to lengthen our keys
Huh. For what database server?
It's not a database server, it's a content management server. This is one of their recommendations for optimising their content model--don't rely on single field primary keys, but extend to two or three fields.
Of course, there's more of an overlay between you and the data than with just a database server, but you also get tagging and multi-values out of the box like Gris is looking for, so as I said--depends on what you're doing and what you want to do it with.
I think I've had it up the wazoo with my Linksys WRT54G. End of life, baby. The devices on my network are faster now than they were when I bought it.
I'm looking to continue on in the DD-WRT tradition. Which router manufacturer should I start my research with? Who's got a good reliability/price combo?
From a quick scan of the DD WRT site it doesn't seem that they support a lot of devices with more than 4 LAN ports. What's the general market look like? I mean has the basic featureset of a wireless router caught up to DD WRT? If I want to run internal DHCP and DNS, for starters, am I likely to be able to get that out of the box?
In old fashioned relational theory, (Codd & Date) the argument would have been that those compound fields should be alternate keys, not primary keys. But it does seem that relational theory has been eaten up by newer models. Even Codd admitted that we need 3D data, which lets in object orientation and so on.
You'll get DHCP out of the box, but I doubt you'll find DNS out of the box. Why do you need a router with more than 4 LAN Ports? You could just get a switch.
I have a Netgear WNR3500L (a gigabyte router with a USB port) which should be very DD-WRT friendly. I'm still using the Netgear firmware though as it ties into the OpenDNS parental controls. Netgear even has a website for the open source alternatives for their routers.
Why do you need a router with more than 4 LAN Ports?
Because I need more than 4 LAN ports in that location, and I'd rather not have *three* chained network devices in my bedroom if I can just have two.
You could just get a switch.
Do they make wireless switches with DNS and DHCP or that run DD WRT? If so, I could just get a switch. But I didn't see any indication that those devices exist. Can you point me in a good direction? The DD-WRT wiki isn't giving me any love.
I'm pretty sure you won't find a switch to do that, I just meant to take care of your need for extra ports.
If a switch would work, it sounds like you're wanting a bridge rather than routing to another network? In which case who's doing DHCP right now?
Well, since I don't think a switch will do everything I need, I don't think a switch will work.
But, honestly, what I want is what I have, but with two to four more LAN ports and maybe some more memory, since I'm right up at the 2MB boundary of the Linksys right now. I don't want a whole 'nother electrical device.
The router does DHCP and DNS, and lo all is almost happy in ita !'s network land. But I'm topped out with devices, and I can't work out if my Win 7 machine dropping off the network is the Win 7 machine, or something to do with the router too.
I have to say, my NAS is doing pretty well--I'm feeling much better about backup, although I haven't done a test restore yet. Still, I'm closer. I just wish it could serve up AVIs with uPNP already. Jesus. Fix my fucking network, will you? I don't want to have a transcoding job running 24/7.
I think you're pretty much stuck with getting a switch if you need more wired ports unless you're going to get an expensive router. 'Course you could convert a PC to wireless to free a wired port.
I've got a 16 port switch and a 5 port switch on my home net to deal with the problem of too few ports. I'm not quite to the point of wanting to rack-mount things.