|
I have a Message class which parses text messages using lookup tables. I receive a lot of messages and create and destroy a lot of objects so I thought I declare those lookup tables as static members to prevent initializing the same tables with the same...
Started by Jack on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Be careful if you have multi-threaded application and if your lookup-tables contain pointer to another data you benchmarked....
That if you have many large lookup tables, performance will increase, but the tables will be hold.
|
|
In a multilanguage application with lookup tables, what's the best way to handle translations?
For example for a country lookup table, a US user should see English country names, as a German should see German names. But still their IDs should be the same...
Started by DR on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Instead of actual text your tables with "locale", "resource key", "resource value" columns that all other tables will use to look up actual detailing the localization....
Is "NO", resource bundles are easier and faster to use than tables.
|
|
Hello,
In an n-tiered application where you are using custom entities, how do you find yourself handling data needed from lookup tables? Do you create entities for each of these lookup tables or employ some other strategy?
For example. I have a "Ratings...
Started by tribus on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I generally don't create entities for each lookup table....
Will depend on how often the lookup data changes, whether or not it needs to be editable, and whether understandable if you put each lookup type into a separate table.
|
Ask your Facebook Friends
|
I have many tables that use Lookup/Enum references for most of their column values. For example:
Person Table - PersonID | RaceCode | HairColorCode | HairStyleCode | TeethConditionCode
Location Table - LocationID | SizeCode | ExteriorColorCode | ConditionCode...
Started by Vyrotek on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Stick with fewer lookup tables rather than-design-mistakes.html....
I made a mistake of thinking all these lookup tables would be a great idea when redesigning our on how many other tables may refer to the same variable.
|
|
I am working on an application which accepts any uploaded CSV data, stores it alongside other datasets which have been uploaded previously, and then produces output (CSV or HTML) based on the user selecting which columns/values they want returned. The...
Started by Alistair Knock on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Yes, the application will have to create....
Also, if in future the users want more columns on a particular lookup then you can add them.
It is more scalable and better for query optimisation.
I would agree that individual tables is preferable.
|
|
I would like to create a lookup table in OCaml. The table will have 7000+ entries that, upon lookup (by int), return a string. What is an appropriate data structure to use for this task? Should the table be externalized from the base code and if so, how...
Started by Mat on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For example, you can start a toplevel:
ocaml strings.cmo
And lookup a string by accessing a particular.
|
|
I have an application where the database back-end has around 15 lookup tables. For instance there is a table for Counties like this:
CountyID(PK) County 49001 Beaver 49005 Cache 49007 Carbon 49009 Daggett 49011 Davis 49015 Emery 49029 Morgan 49031 Piute...
Started by Gary.Ray on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
lookup can have
ORDER BY SortOrder ASC, OtherField ASC
Another programmer suggested using DECODE.
|
|
Let's say you had to calculate the sine (cosine or tangent - whatever) where the domain is between 0.01 and 360.01. (using C#)
What would be more performant?
Using Math.Sin Using a lookup array with precalculated values I would anticpate that given the...
Started by mson on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
However, you'll need to remember that using memory for the lookup table things down in....
As you may have thousands of values in your lookup table, what you may a test to compare the speeds.
tables fit into the caches.
|
|
I'm just learning DDD (Eric Evans book is open in front of me) and I've come across a problem that I can't find an answer for. What do you do in DDD when you're just trying to get a simple list of lookup records?
Ex.
EmployeeID: 123
EmployeeName: John...
Started by John on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
He....
I wouldn't worry about typed repositories for lookup values, but I'd still probably use DTO type classes to the present.
GetCitiesByState (string state); // snip }
Country, State and City are value objects which come from a lookup .
|
|
I have a bunch of tables like this:
Lookup_HealthCheckupRisks ID Name 1 Anemia 2 Anorexic 3 Bulemic 4 Depression ... 122 Syphilis PatientRisksOnCheckup ID CheckupID RiskID 1 11 2 2 11 3 3 12 1 4 14 1 5 14 3 ...
But I need a flattened version, like this...
Started by rlb.usa on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Is you'll have to use dynamic SQL to hard-code very value from the lookup table into a join to your.
|
