I'm trying to do some partial string matching (NodeJS + Express) with a regex on two fields in my MongoDB, but the searches are incredibly slow, even with a (compound) text index on both fields. Collection contains about 300K documents. Looking for someone that can optimize this search so that it runs in under 2 seconds.
This project explores query and fuse knowledge. you will be working with some prearranged knowledge resources and external knowledge resources (DBpedia, Wikidata, FactForge).
I have data of about 5 MB (attached) I want query to display 100 meters from my location (Lat, Long) please check the table (27.721791666666665, 85.32254833333333) as reference point. It works for Geospatial query on mysql. Please show me the real thing on video then i can accept it. Only the successful developer can bid on this.
Please look at the attached file. It contains a sample of a database and a database query written in asp. I'd like a duplicate created, but instead of the columns to the right from 'dd' onwards, the query is to be run with the last 12 fields in the 'EventPlayerStats' table in the database, i.e. 'sgtee', 'sgtee_rank'...
User enters sales order numbers. Stored proc lists all sales orders in the system that have a status type less than '4' and is NOT a parameter of the stored proc, results shows the Sales Order Number, total of each sales order, and stain/color of Sales Order and grand total of all orders.
run dns query with dig statement for alex 10,000 domains for www record and report ttl value, you must use your own dns server i don't care which one, bind, windows but what it matters most it has to have cleared cached, if your are a dns expert you should know what i mean, and generate report and put it into a txt file. You can create a script to
have database with half dozen fields two of which are xtime and xfrom - xtime is datetime field and xfrom is string with phone numbers. I need a query that will get me a listing that includes all records that has the records in descending time order - but has all the phone numbers grouped - so it only uses the time of the first record with that
[url removed, login to view] search functionality to obtain a specific organization. Once that is obtained,you request the web service for the data. Note: a)all functionality is handled by jQuery b)dynamic creation, animation, form validation, browser detection and redirection –all done the ‘jQuery’ way. c)the WADL (Web Application Description Language (XML)) for the servicesi...
Scope: Looking to build a slackbot that is able to naturally query AWS (redshift or s3) and return values. Operation: Develop a list of predefined commands on the front end that link to specific sql commands on the backend to return values to a user (e.g what are sales for company X during period Y)
...are looking for someone to do performance tuning of our amazon redshift cluster. It takes forever for many of our queries to load so I am looking for someone to analyze the database, make recommendations for better performance and implement the recommendations. You must have extensive experience working with redshift and performance turning. I think
Description: Connecting pieces of data, information, and knowledge on the Semantic Web using URIs and RDF. This project explores query and fuse knowledge. you will be working with some prearranged knowledge resources and external knowledge resources (DBpedia, Wikidata, FactForge).