Here's the scenario:
You have a table in your DB, and it contains one filed, USERNAME. Currently,
there are two records, "Alpha" and "Bravo".
You have a cluster with, oh, 5 nodes. Each of them has the "Get_Usernames"
query cached.
Node 3 gets an "Insert New Username" request, and sticks "Charlie" into the
database.
So, how do nodes 1,2,4, and 5 get the word to do a NEW query instead of
using the cached one ???
That's the problem. I've got a solution, but I've been writing some other
stuff and haven't had the chance to buff the solution out to a
presentation-quality state. It'll be coming up shortly. And yeah, its an
NT-based solution, so you Linux folks, shaddup! However, it might work for
y'all, too...
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Erik Voldengen [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 11:48 AM
> To: Fusebox
> Subject: RE: refreshing cached queries
>
> Why would it matter if you were in a cluster? SO the query
> gets run an extra time for each machine in the cluster. So?
>
> Please enlighten me.
>
> -Erik
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
