Hi Sunny， 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
Jie, 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
...card management system , a need to develop alternatives to achieve full functionality. Features include : And existing interfaces hotel room sales management system ( call each webservice form , with the other engineers do ) ; Membership card classification management , distribution , auditing , enable, payment and other packaging ; Corresponding financial statements , business reports ; Query function ; ( Detailed function menu , see Annex photo ) Claim: We had a similar successful projects ; Autonomously communicate with customers , to explore the details of the demand ; Hotels need to travel to the customer site commissioning and implementation of the ( secondary cities in Sichuan Province ) ; Familiar with business processes better ; Please clearly state y...
Requires a database that helps users in our company to organise different packaging specifications for each of our products. Since different customers require different packaging format of the same products, we need to be able to pick from existing packaging format or create new format for each customer. Requires the following functions. 1) Product overview (list all the items, and related different packaging specifications) 2) Functions that allow users to alter and add new packaging format for each item. 3) Functions that allow users to pick different products (and its respective forma) and output the selection to Excel or PDF 4) An import and export function that allows us to import all the existing packaging data into the database.
- Format Chinese text - Graphic design the website - Localize to favor Chinese search engine - Other work needed to get the website up and run in power Will provide the website information later on.
...charge recharge based procedures, similar to VPNExpress , The implementation of user registration, recharge (Alipay & Paypal), VPN account settings, password changes. The user account, close to expiration reminder, enterprise information submitted invoices, invoice mailing address submitted. The OpenVPN function to read, including account surplus time, monthly bandwidth query, history of bandwidth usage information. The interface is succinct, professional, similar to Bootstrap. We have a billing system Hostbill, so if you can develop Hostbill Api, you can not have the development of Web. 一个OpenVPN收费程序, iOS & Andarid & Website(或者使用Hostbill账单系统) 基于OpenVPN的收费充值程序, 类似VPNExpress , 实现用户注册,充值(Alipay & Paypal),VPN帐号设置,密码变更. 用户帐户, 有接近到期提醒,
SQL注入/代码审计/数据库权限/渗透测试技术 接渗透单子高手，联系电子邮箱：aqcp#（#改成@）语言要求：中文 熟练掌握各种内网渗透测试工具与相关知识，精通常见安全攻防技术：sql注入、xss、文件上传、文件包含、命令执行等漏洞 熟悉linux、unix、Windows、oracle、J2EE等各种环境下WEB的安全配置与安全检查及WEB漏洞防范； 熟悉各种脚本语言(asp,php,jsp,java,net、perl、python等)具备独立挖掘web安全漏洞与入侵手段 具备一定的网络安全知识，对网络安全结构、系统漏洞、入侵检测、病毒防护等有深入理论基础和实践经验； 熟悉渗透测试黑客攻防的步骤、方法、流程、熟练掌握各种渗透测试攻防工具有实际渗透经验者优先； 求大虾接单，脱裤，要求，电话，手机，姓名，邮箱，其他的一概不要。每笔单1000美金起步，根据站的难度而定价格,具体可以详谈，寻找长期合作. 态度认真、中介勿扰,请技术实力说话。
我有一个持续工作，之前与之相关的项目为'Convert excel data to APK file(run under android)'
As a company, we have a keen interest in developing partnerships with influencers on Instagram to boost our brand visibility. Our main goal with this project is to create a comprehensive database of potential influencers on this platform. Key Responsibilities: - The primary responsibility of the freelancer will be to search, collect, and organize relevant data about potential Instagram influencers. This will include their follower count, engagement rate, niche, and other relevant information that will help us evaluate their suitability for a partnership. - The database should be easily accessible and user-friendly, with the ability to filter and sort based on different criteria. Ideal Skill Set: - Extensive experience in social media research and data collection, with a fo...
A. give users interfaces that would allow them to do the following: 1. Build unlimited number of customized questionnaires, by adding all common form elements, plus Conditional fields. 2 build unlimited customized search/ query screens by adding same common form elements as their questionnaire. 3. Build customized output/ report screens to present search results. B. All of the above are build on a 100% normalized MySql database, which will become the centralized database for all future data collection, search, and report generation for third party or custom made plugins/apps.
...APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log of all queries made and their results. 4. Response Handling: Identify and record whether results were obtain...
AI Chatbot Saas of existing with only rebranding (colors, logos, fonts etc.) The existing can be found at 7 Days support included after delivery for any query . Duration 5-7 days.
I'm looking for a web scraping expert to help me gather personal profiles, email, and phone numbers from LinkedIn. The data I need should be based on broad search queries. Key Requirements: - Extract specific data: personal profiles, email and phone numbers - Data source: LinkedIn - Search type: Broad search query - Search criteria: Job title or role, Geographic location Ideal Skills: - Proficient in web scraping - Experience extracting data from LinkedIn - Ability to create custom search queries - Prior experience in gathering personal contact information
I need a comprehensive angel investor list for North America in an Excel spreadsheet. The list should cover all the necessary details for each investor, including but not limited to: - Name and contact information - Investment preferences - Industry expertise - Geographic preferences - Industry preferences - Investment stage - Average Investment Amount - Membership model - Membership fees There are additional questions we would like answered. PLEASE READ THE ATTACHED DOCUMENT FOR ALL INFORMATION SOUGHT. The ideal freelancer should have experience in compiling such lists and should be able to deliver a well-structured and detailed Excel spreadsheet. The list should be easily navigable and professional, making it easier for me to reach out to potential investors. Given that I'm ta...
This project focuses on configuring an existing high-performance computer to process and query large datasets using the Llama3 (70b) language model. The objective is to enable efficient data handling and querying capabilities on the local system. Configure the existing computer with the following specifications for optimal performance: CPU: Intel Core i7-12700F GPU: Nvidia RTX 3070 Memory: 32GB DDR5 RAM Storage: 1TB SSD Operating System: Windows 11 or Linux Set up and optimize the Llama3 (70b) language model on the local system. Process 2,300MB of data to be optimized for use with the Llama3 model. Develop a user interface or command line utility to facilitate local data queries using the Llama3 model. Deliverables: Con...
...looking for an experienced MySQL database developer. The central point of the project is database management. • The main responsibility of the developer will be to create a database, and a form page in HTML • and link the form to the database Experience in the field of database and Mysql is necessary. , the form must be elegant and well displayed on laptop and tablet screens. the objective is when entering a reference in the form all the data in the row of the database table will be displayed in the form. if the reference number does not appear in the database the web page generates a message. The successful candidates will illustrate these skills throughout their portfolio in relation to previous projects. If you are self-...
things to be include in that - Register and login option with forget password and reset password with sendinblue email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open l...sendinblue email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open login page and he already login must be redirect to dashboard and wise versa - Profile page -> with image upload Needed basic UI for frontend, we will use boostrap, no other UI lib with mysql must use with proper middleware must be secure way of write the database query need to create from scatch, do not use any ready made template No un-necceeory plugin install Auth must be handle is proper, if requires use redux, no cont...
I'm currently facing an issue on my website where frequent database connection errors are appearing. I'm seeking a knowledgeable and experienced professional who can address this problem diligently and efficiently. Key tasks will include: - Identifying the source of the database connection error. - Implementing a robust solution to eradicate these errors permanently. The ideal freelancer for the job is someone with: - Proficient understanding of database maintenance and troubleshooting. - Proven experience in debugging and fixing similar issues. - Ability to work independently and communicate progress effectively.
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I need a software that checks me in real time an entire database of amazon ASINs in .csv format (3,000,000 asins) , and when the price of one of the asins falls below a price I choose it should notify me on telegram , all with the use of proxy .
...due the data in the database) developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database. I have a python script done by previous contractor who dropped the project for the personal reason, so there is no issues with source and target db structures, mapping of the fields. etc. Need an to refresh and do an extra polish. My specific requirements are as follows: 1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here setup exe file, install it, run trial, restore inventory database from the link I will provide and use this data for the export-import. Paradox DB files are in database folder. ...
I'm looking for a proficient WordPress developer to create a comprehensive relational database for my event marketplace website. This database should not only manage the product inventory but also store a range of user information and details about outdoor activities. Primary Responsibilities: - Developing a robust database to efficiently manage outdoor event organizer product inventory by sector, action, activity, and geo-location. User Information Storage: - The database should be designed to store personal identification and geo-location details of the users, including but not limited to their name, address, and contact details. - It should also be capable of storing users' preferences, which includes their preferred outdoor activities, preferre...
I'm seeking a seasoned FileMaker Pro developer to help address a few challenges with my database. The issues I'm currently experiencing include: - The 'Copy' feature is not functioning as expected. It's failing to accurately copy and paste records along with their associated data. - The 'Time Clock' element is encountering problems with incorrect calculations or logging. - The 'Sort' feature has not been set up properly to ensure consistent and correct sorting of data. Your primary task will be to rectify these issues and ensure the database is working smoothly. Ideal candidates should have: - Proven experience in developing and troubleshooting FileMaker Pro databases. - A keen eye for detail and problem-solving ski...
I require a database model diagram based on a description I will provide. The diagram should serve as a basic overview, capturing key tables and relationships within a relational database. Key Requirements: - Relational Database: The diagram should be tailored for a relational database system. - Basic Overview: The scope of the diagram should be limited to key tables and relationships, providing a clear, high-level representation of the database. Skills and Experience: - Proficiency in database design and modeling - Experience with relational databases - Ability to translate abstract descriptions into structured database models Please note that I do not require documentation on the database model diagram. The focus here is on the...
I'm looking to move my MS-Access database to Azure Cloud. It's currently less than 1GB in size. The process will involve a few key aspects: - **Database Migration**: The primary task is to lift-and-shift the existing database to the Azure platform without any data loss or corruption. - **Data Backup and Recovery**: One of the main security requirements is to ensure that data is backed up regularly and that a robust recovery plan is in place. It's worth noting that there aren't any specific Azure services that need to be integrated, nor any special security measures beyond the data backup and recovery. The ideal candidate for this job should have experience in Azure cloud services and database migration. They should also have a good unders...
...optimization Backend Development: , Flask, RESTful API Microservices, Websockets, OAuth Nginx server management, Kubernetes, Kafka CI/CD integration Databases: RDBMS (MySQL, PostgreSQL) NoSQL (MongoDB) Query optimization, ORM/ODM (SQLAlchemy, Mongoose) Data warehousing, Distributed systems Machine Learning: Deployment Pipelines, Production management Data and Model Pipelines Neural Networks, Deep Learning, Algorithms Applied ML, Network Models Cybersecurity: IDS, SIEM tools, Network Security Linux, Cloud Computing, Cryptography Risk and Incident Management Database security Data Analytics: Tableau, Data Visualization Predictive Modeling, Kaggle EDA, Regression Analysis Project Management, Communication Additional Skills: Docker containerization Cloud platforms (AWS, ...
I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.
...experience to help me build a software solution. The primary goal of this system is to manage a variety of business activities, such as managing schedules, tracking project progress, and more. Key Features: - **Database Management**: The software should primarily focus on data storage, retrieval, and basic data manipulation. Database Management Functionality: - **Data Reporting and Analytics**: Developing the capability to generate detailed reports and perform basic analytics on the stored data will be crucial. Ideal Skills: - Strong experience in Codeigniter - Proficiency in database management - Understanding of data reporting and analytics - Ability to create user-friendly interfaces This project will be a great fit for you if you're looking to work on...
I'm programming a sensitive app where I don't want to have full control over the deployment process / cloud account. Therefore I need a reviewer / ops person to take ownership of the deployment process. I need an hour or so of your time every week to: - Review a pull request created by me - Run a deployment pipeline - Confirm project has deployed successfully - Review cloud account and indicate any issues (e.g. unpaid invoice, server downtime, etc.) Estimated effort / time required: 1-2hrs per week. Note: You don't need to be a programmer / specialist. Just technically literate.
I'm seeking a skilled web developer who can update a music store. I would like to add an auction page, contract management and generator feature. I have updates to user login and music management. Please have experience with audio players and being able to play music while playing an additional mp3 audio tag at a lower volume. Being familiar with ecommerce and using paypal, and stripe for payments. See the attachment for details. Ask all of your questions in the discussion board so everyone knows the question and answer. Please do not submit a fake bid amount and completion time as that will disqualify you. We can discuss everything in the clarification board. We will communicate in chat after I select you as the winner. Thanks!
I need someone to assist me in setting up the Zabor POS APK on my Windows 10 computer. I would like the APK to run on BlueStacks, an Android emulator. This is for personal use, so it is important that the setup is seamless and runs smoothly. Key Responsibilities: - Install and configure BlueStacks for optimal performance - Download, install, and set up the Zabor POS APK - Ensure the APK is running smoothly on Windows 10 Ideal Skills and Experience: - Strong knowledge of Android emulators, particularly BlueStacks - Experience in setting up and configuring software - Attention to detail to ensure smooth operation Please note that I require assistance with the initial setup and configuration - not just running the APK. Your help is appreciated.
Need a Plugin/App to Transfer Google Sheet Data to Database via Webhook URL Description: We are looking for a skilled developer to create a custom plugin or app that seamlessly transfers data from a Google Sheet to our database whenever changes occur. The plugin/app should be able to detect any modifications in the Google Sheet and trigger the transfer process automatically. The data transfer should be facilitated through a webhook URL provided by us. Requirements: 1. Develop a plugin/app compatible with Google Sheets that can monitor changes in real-time. 2. Implement functionality to extract data from the Google Sheet and send it to a specified database via a webhook URL. 3. Ensure the plugin/app is secure, efficient, and scalable. 4. Provide clear documentation and...
...structures. ......" ] } 1 1 (b) s2/s2 : All the 100 queries. Each query has 2 fields: i. qid: The unique id of the query ii. query: The text of the query Some query entries from the file are: { "qid": "1", "query": "deep learning" }, { "qid": "2", "query": "artificial intelligence" }, { "qid": "3", "query": "information retrieval" }, . . . (c) s2/: The relevance values of research papers for each query is given in this file. The columns are: i. qid: id of the query for which the relevance value is marked ii. docno: document id of the research paper for which the relevance is marked iii. relevanc...
...View page during invoice creation in Laravel. 24. Implement company filter and action links for quotations based on type on the Invoice listing page in Laravel. 25. Disable automatic PDF creation when viewing data; display data in HTML view instead in Laravel. 26. Develop a calculator for estimating materials, ensuring compatibility with the old CRM and website in Laravel. 26a. Update the Enquiry database to save enquiries from the website Estimate Calculator form in Laravel. 27. Work on integrating a map to visualize data in Laravel. 28. Implement CRUD functionality for Email Templates in Laravel. 29. Allow selection of email templates within the current module and associate specific module items with them in Laravel. 30. Integrate SMTP for email sending in Laravel. 31. Enable e...
This is a simple C++ command line program with parameters. I don't work with C++ on a daily basis and I need support. The program uses an external SDK, and I have header, lib and dll files. It needs to be connected and configured for everything to work. I present screenshots. This needs to be configured on my computer, I can share the screen remotely.
Google big query - for writing sql queries for the complex data
I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases
I'm looking for a skilled React.js developer to help me run the app locally using or deploy it to sever using anydesk. I will provide a great detailed review. @danielhvoigt/how-to-make-your-react-app-open-locally-through-an-index-html-file-413b0405907
...of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail - Demonstrable ability to classify and categorize data. The goal of this project is to track changes over time, based on the data scrapped. This requires a design that will facilitate easy updates and quick overview of changes. Hence, knowledge and experience in data visualization will be an added advantage. I've added a few screenshots of...
I am looking for a specialist to create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI tes...create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI test cases, with a clear emphasis on user interaction tests. - Setting up and integrating Routing and Guard Components for authorization. - Developing a backend in Spring Boot. - Saving credentials in a MySQL database. Ideal candidates should have solid experience with React Js, Spring Boot, and MySQL database. Proficiency in creating user interaction tests is also a must. Once completed please provide a GitHub link for the project in .docx file with scree...
My current server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maintain high performance - Provi...
I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standards of accuracy and confidentiality ...
I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.
I'm looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past purcha...
My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
I have an online database searching service and I'm looking to upgrade its current features and introduce some new ones. Key Features to Add: - Advanced Search Options: I'm interested in building on my current search function to offer more refined search capabilities. - Scraping: I'm looking to add a data scraping capability to my service. This will involve extracting data from various websites and integrating it into my existing database. - AI Data Analysis: I'd like to incorporate AI data analysis functionality into my service. Specifically, I'm interested in pattern recognition and data clustering. Other Enhancements: - Batch Searching: I need to implement a batch search functionality. - Additional Database Integration: I'm interes...
...noticeable delays during actions that involve fetching data from the MongoDB database, significantly impacting the user experience. I'm seeking a skilled developer who can help me address these performance issues. Key Tasks Include: - Investigating and identifying the root cause of the slowdown when fetching data from MongoDB - Implementing optimizations and solutions to improve the performance of the server actions, particularly those related to database interactions - Testing and validating the improvements before deployment to ensure they effectively address the issue without causing any unintended consequences Ideal Freelancer: - Proficient in and MongoDB - Experienced in optimizing server actions and database interactions for performance - Familiar wi...
I'm looking for a skilled professional to create a comprehensive database ( 10,000 to 20,000) of Non-Resident Indians (NRI) working and/or residing in foreign countries like USA, UK, SIngapore, Canada, Australia, Dubai. Their age group may be between 22 years to 42 database will be used for marketing and promotions for my existing business. Key Elements Needed: - Name - Email - Mobile - Company Name (if available) - Country of Residence or Work Data Collection Methods: - Online Surveys - Social Media Platforms - Public Records Skills and Experience Needed: - Experience in data collection and database creation - Proficiency in using online survey tools - Familiarity with social media data mining - Ability to identify and use relevant public records - Attention ...
