Looking for expert system engineer who can consult and giv solution how to fix on slow query. our project is about ecommerce system and handle multi-product what we found problem is - search product - import product via CSV (which has many process behind) we want fast speed and good approach. we usign laravel backend MySQL DB You can setup
I have txt log files with data. I need to parse data and seperate it into two files. With the data that is seperated i need to seperate it again and then query my database to determine which files do not exist to add data not already there.
It is a tiny task: Creating little function (in a separate module) to query sqlite3 DB to find if particular record exists (I will give the query). If exists, return True or False. Then [url removed, login to view] the function. -Db, table already there -Query already there
I need to someone to help me create a dynamical data structure query in MySQL, with an output from parent to child, as the following: Level | ParentID | ChiledID Output notes: - The results must be in the same order as you see in the excel file. - The query must get the output dynamically. For example, when I insert new level into the table
Hello! Need help to build a laravel query. I'm trying to access the latest messages from a table with content: message_id -> incremented value from_id -> can be either $userId or another id to_id -> can be either $userId or another id message -> the message created_at -> timestamp A user's user id can appear in both the to and from column
...to use database query results. I only have basic web development experience. I just need help adding these database results... <?php $connect = mysqli_connect("localhost", "user123", "pass123", "page_list"); $query ="SELECT page_name, page_url FROM page_list ORDER BY page_name"; $result = mysqli_query($...
I want to make a Round Robin configuration setting in the Kannel for the below message sending given that I have 2 SMSC(SMSC0 and SMSC1). When no SMSC is present in the query string, I like to use SMSC0 and SMSC1 in a Round Robin fashion. This is something like making a Default SMSC setting that will handle those things not explicitly handled by any
...(for example 100km) of a given point. I looked at ST_Buffer but not sure if this will work. All I need is someone to make the query for me and for it to work. To give you the table names for this query, please see below a query used for DIFFERENT application. It retrieves 1 polygon for each point: SELECT * FROM raw_sa1regions2011 where st_contains(SHAPE
Need SQL SERVER Expert Who can build a n level query for json data coming from multiple tables
HI Freelancers I have device which update all detail like, gps , speed , sharp turn, brake etc. We need to build portal as per eld mandate rules on top of this device. and also we need as soon as possbile. please check following link for better understanding and device protocol list for website . mastrack...com/eld (demo website ) [url removed, login to view] (demo login panel ) [url rem...
Hello! We are displaying data from a mySQL 5.1 database on our website. In the past we used an SQL query to gather the following fields from a table: - first_name - city - state - profession - date_of_birth where the "status" field of the user was confirmed. In the past this was easy because all the users were stored in one table (wp_net_user)
Query performance improving in bucketing using map reduce or any algorithm with Hive, comparatively should show the implemantation in Hadoop , on any data set ....for example I wanted to create a single bucket for different different buckets to show that improved performance comparatively than the existing system
Hello - I will be shooting an improvisation film in Paris France in February and March 2018. I am looking for someone who can be on location to load, organize and file footage onto hard drive and cloud space. Please be located in Paris France or nearby. You will need to load footage that will be either Card or possibly mini DV tapes.
Hi I need a sql expert for optimizing sql [url removed, login to view] a small task and I can pay 20$ for [url removed, login to view] sql query has 10-15 joins and running very slow I don’t know how to speed [url removed, login to view] you