Re: more dimensional method like a query...

"Pi421" <jakoeble@xxxxxx> wrote in message
news:1133246847.675036.223860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> the bottle neck is the database

I can't believe that

.... and the middleware the data is passed thropugh.

but I can believe that :-(

> I need to work with this... :(
> I have 64 Combinations.
> first attribute with any value * 4 secsond Attribute with any value = 4
> * third attribute with any value = 16
> * fourth attribute with any value = 64
> so there are psossible 64 combinations of the attributes...

> And at the beginning I need to store the stock depending on every
> attribute

Why? Have you tried linear search on a single collection, testing the four
attributes of each stock?

If that's too slow, create a map on one attribute (the one with the most
variability) to narrow down the number of items you need to search. If
that's still too slow, create a map with two attributes. But linear seach
is very fast on in-memory items, so keep it simple.

> Ans i because of database and middleware i need to cache the stock....
>
Because of middleware, that's sad. Not SOA middleware, per chance?
Application developers should not generally be writing caches. Writing
caches is hard. Soon you'll hit the issues of liveness, expiry, and
revalidation. Databases cache also, and they're better at it than
application developers.

Regards,
Daniel Parker


.

Relevant Pages

  • Re: choices regarding where to place code - in the database or middletier
    ... The concern is not if one database has a sequence and another has an auto ... that mapping up-front. ... executed in the middleware and which ones need to be executed in the ... Do *NOT* code the handling of thsi feature in the ...
    (comp.lang.java.databases)
  • Re: Like I said...
    ... > rich apps running a unidirectional database connection. ... > Can you access regular $50 USB scanners via TWAIN in an app shared ... > updates to the clients. ... you can only do this with middleware ...
    (borland.public.delphi.non-technical)
  • Re: Like I said...
    ... stored procedures on dozens of databases is *much* easier and typically faster than copying a single EXE to a workstation. ... The fact that Citrix is not a REPLACEMENT for n-tier - it is complimentary for all types of applications. ... Eric was saying that Citrix is a replacement for all the middleware frameworks and I'm saying that Citrix has nothing to do with middleware and that the frameworks mentioned above ARE extremely important because it provides a completely different design paradigm. ... Maybe I completely misread what he was trying to say, but if anyone reading this comes away with any info it should be this: if you are developing a large scale app and want the most flexibility: a) don't access a database directly b) have a middle tier that you can centralize your logic in. ...
    (borland.public.delphi.non-technical)
  • Re: Authentication without logging in?
    ... I've been told that it is possible to authenticate an Oracle User using ... The function would return true if USER_B exists in the database and the ... This allows your middleware to run as a 'trusted' user ... but the session ...
    (comp.databases.oracle.server)
  • Re: blanking a java.util.Date in 1.5
    ... so it has nothing to do with 'middleware & database'. ... As you can see from the comments, the underlying date produced does ... not change with the JDK version, just the String representation of it. ...
    (comp.lang.java.programmer)