...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
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.
I have a fully working free radius server that uses mysql for radacct table (and others) but not for USERS list and specifications. It uses the USER file at /etc/raddb. I need to set up the server to use the User file also as a mysql table.
Migrate users, blog posts and forum posts from WordPress site to new social networking site using the Sngine script. Both use MySql database. Please indicate how long this will take.
I am needing to develop a function for woocommerce when new users make a purchase it will give them another for free. Website is a charity business selling tickets, those users then get added into a raffle where a winner is drawn. We are using - woocommerce + WP Raffle This project is very very urgent.
We are looking for several designers that can use Archicad 20..must be At least 3 plus years experienced. must know how to use inches and feet. must know basic design fundamentals...
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
"validation while uploading subscriber (from .txt,.csv copypaste) show invalid email in UI by calling API" show invalid email on popup or any UI in table format pattern/domain/smtp using checked and cross
Since our new website is using wordpress with user fea...with user features of registration and edit profile, I would like to synchronize the wp-user and wp_meta database with our existing database in both directions. Tasks are 1. Display the users with different settings 2. Add/Delete/Update users in one of the two databases See document included