The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
# 2013년6월 ~ 2013년12월 : 고양시 상수도 블록시스템 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, ibatis, amchart, eazy-ui # 2014년1월 ~ 2014년3월 : 고양시 상수조 블록시스템 GIS적용 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, iBatis, O2Map, OpenGIS # 2014년4월 ~ 2014년11월 : 주유소 누유관리 모니터링 시스템 - 고객사 : (주)에스티모빅 - 근무사 : 프리랜서 - 사용기술 : Java, Spring, MySql, MyBatis, jqgrid, bootstrap, daum map API, plot-chart # 2014년12월 ~ 2015년2월 : 생산관리 ERP설계 - 고객사 : (주)금강이엠씨 - 근무사 : 프리랜서 - 사용기술 : mockup UI tool # 2015년3월 ~ 2014년4월 : 블루투스 BLE 비콘통신 Android 개발 - 고객사 : (주) 바이트시스템 - 근무사 : 프리랜서 - 사용기술 : Android (블루투스 BLE 비콘통신, 서버 소켓통신) # 2015년7월 ~ 2014년8월 : 임베디드 리눅스장비 웹관리 프로그램 - 고객사 : (주)제이앤씨시스템 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술...
php, mysql, word press, bootstrap, jquery , ajax, html5 (모바일웹, 앱) 기술 우대
...responsibilities include database management, backend development, API integration, and connecting the frontend to the backend. The project requires connecting Razorpay as the payment gateway and Shiprocket as the delivery partner. The frontend design will be provided as custom HTML, CSS, and JavaScript. **Responsibilities:** 1. Implement database architecture and management using Laravel's ORM. 2. Develop backend functionality to support the e-commerce website's operations, including user authentication, product management, order processing, and more. 3. Integrate Razorpay for secure and efficient payment processing. 4. Integrate Shiprocket API to facilitate seamless order fulfillment and shipment tracking. 5. Connect the frontend to the backend, ensuring prope...
I need a skilled Flutter developer to create a medical diagnostic app. This app will be used to collect blood cell images or videos. Here are some specific features the app will need: - User authentication - Push notifications - In-app purchases Also, the app should be capable of capturing and storing High-Definition (HD) images or videos. If you're adept with Flutter and have some experience in creating medical or diagnostic apps, your expertise will be highly desirable for this project.
I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for user-frie...
I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.
I am seeking a skillful developer to integrate an "in app chat" feature into my existing .Net MVC5 aspx SAAS project, with a particular focus on real-time communication functionality. Key Expected Features: - Bootstrap 3 compatibility - Chat server - Client (html and jQuery preferred) - Ability to create groups (add and remove participants) - Show users online status - Storing chat history - Ability to send/receive documents and audio files Ideal freelancers for this role should possess the following skills and experience: - Proficient in .NET MVC5 and Bootstrap 3 - Experience in chat server and client development - Ability to write clean, maintainable jQuery and HTML - Familiarity with real-time communication platforms UI Presentation: The chat messages should be dis...
I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.
We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.
I'm looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here'...
I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.
I'm seeking a professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please feel free ...
I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voi...system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specifi...
I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tracked include the part number, description, supplier information, purchaser details, condition, make, model etc. In the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application need...
As the developer of an existing project written in Python, SQL Server, and MongoDB, I am current...bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I will share my screen through teamviewer or anydesk and you need to read the co...
...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL....
I'm in need of a seasoned .NET developer who possesses the following expertise: - Skilled in developing Web API - Knowledgeable in MySQL as a database system - Need 5+ Years Experience This is a personal project and I'm seeking someone reliable, efficient, and with a firm grasp on these skills to ensure successful implementation. If you have the experience and are keen on a unique personal project, I encourage you to bid.
...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL....
...manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requirements ...
I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a syste...
I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
We're in need of an advanced Python programmer well-versed in creating PDF reports from MYSQL and InfluxDB, capable of not only capturing numerical data but transforming it into Graphical Trends and Text-Based Analysis. Key Role: * Develop logics for data interpretation and representation * Create a Professional and Formal UI/UX design for the report generator * Deliver finalized, error-free reports Ideal Experience: * Python expertise * In-depth knowledge of MYSQL and InfluxDB * Proven experience in creating dynamic PDF reports * A keen eye for formal and professional UI/UX design * Strong abilities in abstract reasoning and complex logic writing. Your role will translate our complex database information into understandable, well-structured and...
I'm looking for a PHP script expert who can create a real-time data retrieval system for my MySQL database. The script will connect to the BeachesMLS Matrix RETS Server and download all the properties into my database as soon as they are sold. Key Requirements: - Real-time Data Retrieval: The script should constantly monitor the BeachesMLS Matrix RETS Server and instantly download all the sold properties into my MySQL database. - Comprehensive Property Details: The script should specifically download details like price, location, size, agent information, property status, listing date, amenities, property type and the number of bedrooms for each sold property (all fields available) Ideal Skills and Experience: - Proficient in PHP: You...
I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.
With a pressing need to secure our Laravel and MySQL voting system, we are looking for a skilled professional who can rectify the voting manipulation issue we are currently experiencing. Here's what we need: - Expert in Laravel and MySQL - Experience in securing web voting systems - Proficiency in server request handling is crucial. We have already introduced a new security measure related to server request handling, but our voting results are still being tampered with. We need an expert to identify the lacunae in the existing system and beef it up to prevent any future breaches. In addition to a strong technical skill-set, your knack for problem-solving would be greatly valued on this mission to restore integrity to our online voting system.
...just meant to run on any given localhost machine as a project. I'm in need of a skilled developer to build an application for a project. The main focus will be on exploiting the 'Academic World' dataset, incorporating relational (MySQL), document (MongoDB), and graph databases (Neo4j) which will be provided. Key Functionalities: - See .docx (My Approach) Section This is a project-based task, so I don't think there's a need to implement complex user authentication or intricate access control. Candidates with experience in web-based application development using MySQL, MongoDB, Neo4j will be ideal for this project. Understanding of library management systems and dataset manipulation will be highly valued. Your expertise in creating user-fr...
WordPress site WordPress / MySQL / AJAX / jQuery / PHP / React.js / JavaScript Project Overview This is a simple data driven WordPress site. User 1 registers as a member of “Class 1” User 1 enters a number into class 1 User 2, is also a member of class 1 User 2 searches that number entered by User 1 and is provided instant AJAX search results. User 1 can edit and delete data in his history. User 2 who is a member of class 1, 2 and 3 can view data entered into class 1, 2 and 3. (The chosen classes chosen in the profile. Users can register for up to 3 classes) User 3 who is only registered in class 4 can only view data entered into class 4 I’m needing a bid on the cost and time required to build out this project. If you will be avai...
I need a highly skilled NODE (puppeteer) expert to undertake a database integration task with my Aviator Game. The game requires MySQL database inclusion and specific features. Key Duties: - Incorporate MySQL database into Aviator Game - Set up the game as needed Essential Features: - Creation of User profiles within the game - Implementation of Leaderboards system Skills and Experience Required: - Proficiency in NODE (puppeteer) language - Extensive experience in MySQL database integration - Familiarity with custom PHP programming
I'm looking for a professional who can ...from a website that I will share with you. This data should be filtered according to specific product details. Key Requirements: - Retrieving product information including SKU, Category, Sub-Category, Color, Gender, Age, Material, Sleeve Length - Implementing a filtering mechanism to sort and organize the scraped data - Attention to details for accurate data scraping The ideal freelancer for this job should have: - Experience in web scraping and data mining - Strong understanding of data sorting and filtering - Proficiency in managing and storing large sets of data - Excellent communication skills to understand and address any queries regarding the project Looking forward to working to...
We developed a web portal using PHP and MySQL to be used at places where Internet speed is slow, but it is taking long. We have about 20,000 records and they will quickly grow to a million and more. Here is the PHP code and MySQL database:
As a comp...permitting only those with valid access to work on it. - Database Integration: The application should be structured to flawlessly integrate with our databases, strategically managing our internal data. - Responsive Design: Given the multitude of devices we use within the company, the application should be responsive to all, providing a smooth user experience no matter the device. An ideal candidate would have prior experience in building full stack applications with emphasis on the aforementioned functionalities. Further, expertise in Database management systems and designing responsive applications will be crucial to the successful completion of this project. The application will not be capturing or storing any additional data other than...
We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.
I'm in immediate need of an in-app SEO professional to configure my webapp. When shared on WhatsApp, Twitter, Telegram or any other third-party platforms, the content must appear with a thumbnail. Th...any other third-party platforms, the content must appear with a thumbnail. The perfect candidate for this task has: - Expertise and a strong understanding of in-app SEO, and how different social platforms display shared content. - Experience with webapp configuration. - An immediate availability, due to my requirement for swift project completion. The webapp was build with backend php laravel, MySQL, frontend tailwin css vue.js Remember, the more detailed your proposal, the more likely I am to consider it. Including some examples of your past work would be advantageous. Don...
...stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and interactive platform. For this project, the ideal freelance...
...Planos ( Para Liberar Mais Recursos EX: Permitir Comunicação em Massa) - WEB: Funcionalidade Base Administrativas: Gerenciamento de Usuários Gerenciamento de Parceiros Email Marketing (Integração) Gestão do Gateway de Pagamento Gestão Financeira Estatísticas de Uso Gestão de Cupons Gestão Geográfica e Mapa de Calor com Filtros Integração com Google Firebase Integração com Google Analytics Integração com Google Data Studio Ferramentas Proprietaria Para ADS ( Melhor Posicionamento nos Resultado, Push, Envio em Massa de Chats, Etc..) - Requisitos técnicos: Compatibilidade com Sistemas Operacionais: Android: Suporte a vers&otil...
We developed a web portal using PHP and MySQL to be used at places where Internet speed is slow, but it is taking long. We have about 20,000 records and they will quickly grow to a million and more. Attached is the requirements document, PHP Code and MySQL Database. This is quite urgent. PHP Code and MySQL is here:
I'm looking for a professional who can help me deploy my Spring Boot Maven with MySQL and React app to Google Cloud Platform. Key Responsibilities: - Deploy Spring Boot Maven with MySQL and React app to Google Cloud Platform - Ensure the deployment is running smoothly and is accessible Ideal Skills and Experience: - Strong experience in deploying Spring Boot applications - Familiarity with React app deployments - Prior experience with Google Cloud Platform - Knowledge of CI/CD pipelines is a plus, although not required in this case - Proficiency with Git for version control Looking forward to your bids!
...a comprehensive web application that can handle various data-related tasks, from generating PDFs to processing scannable sheets, creating data visualizations, and interactive reports. The ideal candidate for this job should have experience with PHP, MYSQL/MariaDB, and an understanding of data processing and visualization. Key features and requirements: - PDF Generation: The application should be able to take XLSX files, and based on the uploaded data, generate PDFs. - Scannable Sheets: The system must be able to process bulk uploads of scannable sheets, interpret the data (including pencil bubbles), and translate it into tables. - Error Reporting: I need the system to either prompt users to fix any errors or flag errors for later attenti...
I'm looking for an experienced developer who can help me set up a secure and efficient hosting solution for my crypto-related project. The hosting will be used for storing cryptocurrencies securely, running a blockchain node and potentially hosting a crypto-related website. As such, I need a professional who can deliver top-notch security measures for this hosting project. Skills and experience required: - Experience in crypto hosting, blockchain technology and cryptocurrencies - Ability to set up secure hosting solutions with advanced encryption and authentication. Please include any relevant experience in your application. Read article to get a better understanding No time wasters I need it
I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of...- Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide examples of similar projects you have worked on, and explain your approach to modifying WordPre...
I have MySQL running on my Linux system and I'm looking for a professional to help me install Kannel and set it up as an SMS Gateway with fake dlr
In my ongoing project, I'm facing a thorny issue. Some numeric data is missing from the transaction data table in our MySQL database report. In order to move forward with my work, I need a professional to: - Diagnose the source of this missing data - Fix the issue to ensure all numeric data is correctly pulled into the report from the transaction data table The successful candidate should have: - Extensive familiarity with MySQL databases, specifically in generating and troubleshooting reports - Sound understanding of database architectures and data tables relation - Proven problem-solving abilities I look forward to your proposals and getting our report up to speed.
Knowledge of technology required -> Frontend: ReactJS or Vue.js or AngularJS Backend Language: PHP Framework: Laravel Database Modeling: MongoDB, PostgreSQL, MySQL We want to create a CRM app with MERN/MEAN stack or Laravel and JS.
I require a skilled developer to enhance the functionality of the Shopware 6 / JTL ERP Connector by incor...to enhance the functionality of the Shopware 6 / JTL ERP Connector by incorporating custom fields specifically for storing additional product information. Key Requirements: - Creation of fields for file upload parameters (Shopware 6 Plugin) - Fields for tabs in the item description - Inclusion of a field for maximum quantity The goal of these custom fields is to better store and organize product information within the system, and enable a smoother experience for both customers and the backend team. Ideal Skills and Experience: - Proficiency in Shopware 6 and JTL ERP - Prior experience with similar customization projects - Strong understanding of e-commerce systems and da...
...WordPress website's database. The primary reason for this is to lower hosting costs. Key Areas for Optimization: - **Back-end Operations Speed**: The site's backend is significantly slowed down due to the large database. I need a solution that will significantly improve the speed of my back-end operations. Data Types to Address: - **User Data**: The large volume of user data on the site is a significant contributor to the database size. I need to find ways to optimize or archive this data without compromising its integrity. - **Media Files**: The site is media-rich, and the files are taking up a lot of space in the database. I need to find a way to reduce the size of these files without compromising the images or video...
...background with NextJS 14, TailwindCSS, and NodeJS and some knowledge of RestfulAPI and MySQL. Deliverables: - Develop the front-end based on the provided Figma files, with provisions for client-side and server-side rendering features that will be added by the back-end team. - Collaborate with the project and back-end team to understand project requirements and objectives. - Develop reusable UI components and design patterns to ensure consistency and maintainability across the website. - Implement responsive design techniques to create seamless user experiences on various screen sizes and devices. - Update the framework and implement the latest features using NextJS 14. Skills: - Proven experience in UI/UX design for web applications. - Excellent English - Proficiency in...
