Hi all.
I am running MySQL 3.23.22 on RedHat 6.1. I have an Apache 1.3.9 server
running PHP4pl2.
I am having trouble creating a search engine to search the database and
return results based on the # of times dynamic keywords are matched across
multiple fields. I want to add onto a 'score' column for each keyword
matched but have no idea on how I might do this.
So far, I can create
In my app I need to publish messages to clients that fits mongodb criteria.
I wonder what is the best way to do it using redis pub/sub.
Here is my thoughts:
1. Each client has own private channel. So after finding clients that�fits�criteria publish notifications to their private channels.
2. Don't perform search. Publish message to all clients. Check if client fits criteria manually inside suscribe
Hello Everyone,
What is the best schema ? Is there a recommended strategy or criteria ?
Option 1:
user {
_id: ObjectId('asda1233eqww'),
name: 'adsads',
email: 'asdas@assa'
gallery: [
{ name: 'photo1',
url: 'http://addas.com/ads' } ,
{ name: 'photo2',
url: 'http://xcvvxs.com/czc'}
}
]
}
or Option 2:
// Users Collection
user {
_id: ObjectId('asda1233eqww
Hi
I want to display data based on the criteria selected by the user eg click
location etc etc
what is the code I need?
Thanks.
DC
This is the tersest model watcher, through which you could do a speculative (automatic) save that isn't every keypress, so that the server is not flooded :�http://jsfiddle.net/cn8VF/�(tis not my fiddle, thanks whoever).
I wonder if there's is need for something that's built in to Angular (from the ngResource page example) ......
var cards = CreditCard.query(function() {
// GET: /user/123/card
my MongoDB document looks like this:
{StatCode : "...", LoadTime : "..."}
For example, the data might look like this:
+-----+----------+------------+
| _id | StatCode | LoadTime |
+-----+----------+------------+
| 1 | 200 | 0,345 |
| 2 | 200 | 0,234 |
| 3 | 200 | 0,396 |
| 4 | 200 | 1,234 |
| 5 | 200 | 2,564 |
| 6 | 200 |
Hi all,
I need to execute a Solr query in two steps, executing in the first step a
generic limited-results query ordered by relevance, and in the second step
the ordering of the results of the first step according to a given sorting
criterion (different from relevance).
This two-steps query is meaningful when the query terms are so generic in
such a way that the number of matched results exceeds
I have a table with a "state" field, and often I want to get only records
matching those states, ordered. This simple query
Select * from my_table where state='NJ' order by table_id DESC
is relatively slow because of the order by clause (where there are a lot of
matching records). I've tried everything I can think of to speed this up --
indexing state and ID together, extracting the
I want to be able to sort a list of users by how much they've spent in the
last 6 months.
The document has a structure of:
{
"type":"user",
"purchases": [ {"type":"purchase","time":"2012-11-05
17:37:52","spent":50}, ...]
}
Here's how I'm planning on writing the index:
var cutoffDate = new Date();
cutoffDate.setHours(0,0,0,0);
cutoffDate.setMonth(cutoffDate.getMonth() - 6);
var total6m = 0;
I have a collection which is going to hold machine data as well as mobile
data, the data is captured on channel and is maintained at single level no
embedding of object , the structure is like as follows
{
"Id": ObjectId("544e4b0ae4b039d388a2ae3a"),
"DeviceTypeId":"DeviceType1",
"DeviceTypeParentId":"Parent1",
"DeviceId":"D1",
"ChannelName": "Login",
"Timestamp
How can I formulate a query to return elements that match multiple criteria
of a embedded document?
*I've got data that looks like this:*
{
_id: 100,
type: "food",
item: "xyz",
qty: 25,
price: 2.5,
ratings: [ 5, 8, 9 ],
memos: [ { memo: "on time", by: "shipping", "subject": "warehouse" } ]
}
*I've got a query that looks like this:*
db.inventory.find(
{'
Hello, I'm wondering if this is the most effective way of doing an
outer join with 'extra criteria' (I don't feel like it's the best way):
SELECT e.EventID, ue.Contact, ut.Discount
FROM Event e
LEFT OUTER JOIN
(SELECT EventID, Contact FROM UserEvent WHERE UserId = 10) ue
using (EventID)
LEFT OUTER JOIN
(SELECT EventID, Discount FROM UserEventType WHERE UserID = 10) ut
using (
Is there a way to do a select for a certain criteria over several fields
without individually specifying each field? EG I want to search for abc in
field 12, 34, and 56. I can do this by typing select (12, 34, 56) from table
where 12 like '%abc%' or 34 like '%abc%' or 56 like '%abc%'
Is there a way to specify it something like select (12, 34, 56) from table
where (12, 34, 56) like '%abc%'.
Hi,
Did any one use or in the where clause combined with an and condition?
Any ideas how to use NVL function in Ibator?
Thanks
Vinaya
This electronic message is intended only for the use of the individual(s) or entity(ies) named
above and may contain information which is privileged and/or confidential. If you are not
the intended recipient, be aware that any disclosure, copying, distribution
Hello,
I am wondering if it is possible to place selection criteria when reading in the preference data used by taste to make predictions. For instance: I only want to use users who have reviewed more than 15 items. This is a data cleansing step that I can take care of before feeding the data to taste. If there is something built in though, it would make my life a bit easier :)
Thanks
ChrisS
Hi,
I want the jobtracker to prioritize the assignment of tasks to certain
tasktrackers.
eg: If a tasktracker meets certain criteria better than other ones, I want
to assign task to that tasktracker first (ideally I want the jobtracker to
sort tasktrackers based on certain criteria (eg cpu frequency) and then
assign tasks to tasktracker based on that sorted assignment.
Could you point me to the
how can i know the number of documents removed by a .remove(criteria)?
Hi,
I am new for mongodb-10g. I have just started study mongodb-10g. I am done with some basic mongodb tutorial. And now I want to design database for my requirements.
Requirement
1) I have a unique key, and there may be 50,000 different keys.
2) I received approximate 20 records/minutes per key.
3) And records may be have different types (among 100 types).
So I've reached a bit of a dilemma. I'm creating a tool that allows
users to filter records -- the typical x (gt|gte|equals|begins with|
ends with|etc) y. I'm being forced to use the .where() functionality
instead of just putting together one dict with all the criteria
because I'm trying to match int fields with regexs to allow the user
to filter by "int field begins with 2".
So the problem
Hi,
i have a use case where We would like to know what are the users searching
for. Most commonly used criteria etc.
is making each search but this is not criteria itself. It is just analysis
information.
I was wondering what is the approach to add to the query to be logged
analytical information which is not searchable and which is the best
approach to do analytics on Solr.
For Instance