...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 tool : [url removed, login to view] or
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.
Hello. Well, alright, I need to collect data from simple web forms - like marketing polls, contact form and so on. The solution has to be: 1) easily embeddable to an average html page; 2) centralized. The forms entry should dump on a particular machine. Using a simple server app would be just perfect; 3) flexible. Although the forms are going to
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
...created a jQuery DataTables table using a static data array. I need to change this 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...
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
...currently have a MySQL Geometry database which is filled with MultiPolygons. I need to retrieve all polygons within a certain radius (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
Need SQL SERVER Expert Who can build a n level query for json data coming from multiple tables
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
...reflect entries such as "white", "blue" or g"grey" , not the actual position as you showed in column A Column A and Column G - should be cleaned as specified in slide 2 of the powerpoint I sent OUTPUT: database 1: external data entries that are NOT found in internal data database 2: external data entries that are f...
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
We are a new custom tour design operator that will operate out of the Middle east and focus on this region as well as Africa to start with and then offer tours to other worldwide regions also. For now we will focus on 4 main areas that I would like blogs to written on that will be posted on the website systematically over the next few months. The aim of the blogs would be to promote our focus a...