|
A former coworker insisted that a database with more tables with fewer columns each is better then one with fewer tables with more columns each. For example rather than a customer table with name, address, city, state, zip, etc. columns, you would have...
Started by raven on
, 17 posts
by 17 people.
Answer Snippets (Read the full thread at stackoverflow):
Other engines might prefer it the other way around tables/columns, but about normalization.... .
That's also the more 'normalized' approach.
MS SQL Server, for example, tends to prefer more narrower tables.
It depends on your database flavor.
|
|
A CUP OF JO: The Best Chocolate Ice Cream You'll Ever Have#more#more#more#more
Started by Shannon Hunter on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at pinterest):
|
|
We have an ASP.NET project (40 or so Web forms, 50 tables, pretty standard IO stuff with care taken to minimize when possible) that will soon need to be deployed. There will be about 100 concurrent users on the system, but only about 20 at any one time...
Started by rp on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Utilization? Only if you're shooting for >3.5GB of ram.
It's impossible going to be hitting disk a lot more.
Monitor the memory pressure and cpu load, and buy more/upgrade as necessary.
|
Ask your Facebook Friends
|
Suppose I have a page called mysql_query_performance.php which contains code to select some records from table and echo it.
But I want to know how can I simulate more than 1 request to test the performance of that query?
Is this Possible? If yes, How?...
Started by Hitesh Chavda on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Ab -n 4000 -c 10 http://www.yoursite.com/mysql_query_performance.php
That's for 4000 requests ... .
It's most likely already installed on your system.
You could use Pylot:
http://www.pylot.org/ For simple load testing, you might want to try Apache Bench .
|
|
Is PMBOK more for after implementing software is built, delivering it to the customer while Agile or Scrum is more for building the software in the first place? Just trying to understand.
Thank you.
EDIT: My main concern is the PMBOK. They use it a lot...
Started by johnny on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Remember not to confuse the PMBOK.
Switch in more of the agile processes to finish off your project.
|
|
Hey,
I'm considering an upgrade in my servers. I can not decide if I want more servers, or fewer servers with a high unit thickness and possible virtualization. My servers have high mySQL query demand and low storage requirements. All opinions are welcome...
Started by storm on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at serverfault):
They're also usually highly....
We would need to know much more about your workload and datacenter to provide advice more targets.
The only real reason to get "taller" servers is if you need more storage or many PCI[e|x] IO cards question.
|
|
Yesterday I had a team leader of another team say that they took a while to figure out something I wrote on a wiki page because I referred to obtaining code from source control as "checking out" which apparently confused them. They said that they were...
Started by digiarnie on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
They have more important responsibilities like keeping people away a feel."
Team leader/technical....
It is possible to find both a manager and a leader in the same person, but more often the roles (should keep their hands out of the code.
|
|
Let me start by saying I'm a huge fan of the elegance of this pattern -- I have a group of basic entities that I have implemented builders for (specifically for testing). However I have found (and this may be the caveat) that as my program evolved I kept...
Started by Watson on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Moreover with mocks you could make the test objects be more than simple stubs, and actually participate is close to what they need so they add....
Framework , which makes it more convenient to produce domain test objects with a known state.
|
|
Hello to all,
I am setting up a system to host WordPress blogs for users of a site I run. Right now, things are functioning pretty well within one database and different blogs running with their own prepended tables ( user1_posts , user_posts , etc).
...
Started by Nicky Hajal on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
If you're using MyISAM, performance will suck incredibly badly if you have more tables than.
Using.
|
|
Hey guys, I am wondering from you DSMLink users what you think is more beneficial for you in terms of power. In your experience, have you found that running more boost (20lbs) with more timing retard makes more power, or less boost (15lbs) with more timing...
Started by imagine3163 on
, 30 posts
by 15 people.
Answer Snippets (Read the full thread at dsmtuners):
Then once timing....
More boost gets more power....I run 25psi on my E316g setup on pumpgas with relatively low timing more aggressive with the timing advance the higher the rpms rise, in the lower rpms you will want much less timing.
|