Ways of searching an excel file in asp.net
Consider i have an excel file >200000 rows in it. What is the fastest way that can be implemented to search a partcular column value in this file using c# asp.net. Any suggestion. ...
search
Using binarySearch with Comparator and regex
Hi. I am trying to write a quick search that searches a List<String> Instead of looping through the list and manually checking, I want to do this using binarySearch, but I am not sure how to do it. Old way: for(String s : list) { if(s.startsWith("contact.") return true; } Instead I would like something like this: Collection...
Zend Lucene MoreLikeThis
I'm using Zend_Search_Lucene for my search engine. Sadly it is missing an implementation of the MorelikeThis methods which can find similar documents in the index. Has anybody come across a decent Zend port of this function? I found a drupal module but have no idea if this can be used with Zend without some serious hacking. ...
Search in array
$total is an multi dimension array: Array ( [1] => Array ( [title] => Jake [date] => date ) [2] => Array ( [title] => John [date] => date ) [3] => Array ( [title] => Julia [date] => date ) ) How to search for [title] value and give as result ID of an array? If we search for Julia it should give 3 (ID is [3]). Thanks. ...
Need help searching through source code
Hello all! I was hoping that someone could give me some tips and point me in the right direction as far as searching through complex source code. For example, I am looking for the various POSIX system call implementations. Say I wanted to find the implementation of open(), how would an experienced programmer find this? I am familiar w...
Binary search implementation with actors in scala?
Hi, So I have such problem in Scala, I need to implement binary search with the help of actors, with no loops and recursion, preferably with concurrency between actors. Of course it has no sense, but the problem is as follows. I think that it will be nice to have one actor-coordinator,which coordinates the work of others. So input data ...
How can I view the original SQL that created a stored procedure in SQL Server 2008?
The title pretty much says it all. How can I view the original SQL that created a stored procedure in SQL Server 2008? Is this possible? I've been searching online for some leads, but I'm either missing correct vernacular or I'm just looking for something that can be found by some other means. My basic problem is that I've got a SQL ...
Twitter search with source parameter from oAuth application
Would anyone happen to know how you would run a Twitter search query based on a tweet coming from an oAuth Twitter application (source)? For example, I want to be able to pull tweets that were posted from my Twitter application and be able to find it using the 'source' operator. Thanks in advance. ...
What is the best way of searching mysql table field for the ending of a fiels?
I have been told that searching in a MySQL database with LIKE '%wordend' is bad because it takes very long time. What is the best way of searching on the end of a field? Should I make an extra field where field that needs to be searched backwards is stored backwards, seems like an ok idea to me since it will give the benefit of indexin...
fastest way to search text value for words in SQL Server 2008
I have a requirement to identify keywords stored in a table column in text passed to a stord procedure, at present I'm pasing the text in as rows in a table value, however as populating the table value is hideously slow, I'm going to scrap this approach. I looked at the full text search option, however based on my very limited understand...
Search memo field using space-separated keywords?
given the following test records ID, MemoField 1, "apples oranges mangoes peaches" 2, "oranges bananas apples" 3, "oranges plums cherries" 4, "bananas cherries kiwi" and having keywords entered in a single text field as: "apples oranges" I want to be able to return records 1, 2 and 3 because those records either contain apples or ...
Search a query in multiple MySQL tables
hey guys i just want to search ( Select ) in multiple tables , so i wrote bellow code : SELECT s.title From table_stories s WHERE s.title = %$inputbox% UNION SELECT e.title From table_pages e WHERE e.title = %$inputbox% is it wrong to use UNION >?! ...
Search query and keyword phrase algorithm
I am looking for an algorithm that will efficiently separate a search string into an array of known search phrases. For instance, if I type "Los Angeles pizza" it needs to know I am looking for "los Angeles" and "pizza", not "Los" and "Angeles pizza". This is for a specialized search application, assume I have a dictionary of all phras...
What's the fastest way to make a multiple field search in MySQL?
Hi there! I'm trying to achieve a really fast search engine for a MySQL db with several fields. The problem relies on the fact that I need to match a value (keyword) against several fields, in a %like% approach. I don't mind relevancy (the order is fixed), just performance. The queries are pretty complicated (lotta JOINS, 3 or 4 tabl...
Proper way to call a database function from Django?
Hi, i'm triyng to make a full text search with postgresql and django So I've created a function search_client(text) which returns a list of clients. To call it from the DB i use something like this: SELECT * FROM search_client('something') and i'm not really sure how to call it from django. i know i could do something like cursor = c...
Lucene - how to make multiple words within query AND instead of OR together
I am using Zend Search Lucene and if the user types in Vibrant Bouquet into the search box, results with the word "Vibrant" or the word "bouquet" (or both obviously) are returned. What I want is only to return those results with both words. Obviously I can do this by typing AND between the words, but as far as I can tell Lucene implicit...
How can I avoid separating the search query to search a MySQL database?
When a user tries to search for people on our system, we've noticed that they often type a full name for their search. How can we enable full name searching on our database when first name and last name are stored in different columns? ...
Searching a JTree
I've got a JTree, which I am trying to search. I've written a quick recursive search function. The function takes a parent/child node name pair as a string. private void RecursiveSearch(javax.swing.tree.DefaultMutableTreeNode node, java.util.ArrayList<TreeNode> nodelist, java.lang.String destination, java.lang.String origin) { node...
Can you use dynamic finders or grouping tables via scaffold in Grails?
I'm working on a very, very quick and dirty application using almost entirely scaffold to do it. This is only for internal use, and it's just to replace a spreadsheet, so while I know that I shouldn't rely on scaffolds for real production use, I still intend to use them where I can for efficiency (...just wanted to make sure we aren't ta...
Magento search result to my way
Hi, i've been triyng to change the default result page of magento, i want the products grouped by categories, it don't include the subcategories but the products, the search criteria is the product name, so, i was triyng to use the defalt simple search of magento, untill now no result, maybe i have to override the search and make a new o...