|
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.
|
|
I am creating RESTful services for several database entities based on a modified version of the BISDM . Some of these entities have associated lookup tables, such as depicted below:
The lookup tables are associated with one and only one table. Additionally...
Started by Ryan Taylor on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Yeah, it's nice that....
Don't.
If it's for client-side validation, then the second, if you're expecting clients to use the lookup tables to do lookups themselves ...
You're exposing the lookup tables in the first place.
|
|
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.
|
Ask your Facebook Friends
|
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.
|
|
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 am developing an app that utilizes very large lookup tables to speed up mathematical computations. The largest of these tables is an int[] that has ~10 million entries. Not all of the lookup tables are int[]. For example, one is a Dictionary with ~2...
Started by snazzer on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
That was more database oriented, and build the lookup table in a lazy fashion from the DB (ie: a lookup is lookup in the LUT, but if the lookup doesn't exist, load it from the DB and save it in the table of the....
|
|
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.
|
