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월 : 임베디드 리눅스장비 웹관리 프로그램 - 고객사 : (주)제이앤씨시스템 - 근무사 : (주)제이앤씨시스템 계약직 ...
Setup Nginx on Plesk control panel with magento website Works fine with apache, we just need to change it to Nginx, you will need to set this up.
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating da...
...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database...
I'm in need of an Oracle Fusion Finance Technical specialist with around 7 to 12 years of experience. This remote, long term assignment focuses on: - Customization: Tailoring the existing software to better fit our unique business needs. - Integration: Linking the Oracle Fusion system with our other platforms to streamline data flow. A thorough comprehension of the following Oracle Fusion Finance modules are necessary: - General Ledger: To maintain our financial records efficiently - Accounts payable: Ensuring proper handling and tracking of our expenses - Accounts Receivable: Optimizing revenue collection process The assignment is expected to be a long-term engagement. Ideal candidate should be technically proficient and possess strong problem-solving skills.
Project Description: We are looking for a skilled Java developer with experience in Apache Flink (version 1.19) to create a data processing job that reads from parquet files located on a Network File System (NFS) and sends selected data to a Kafka topic. Core Responsibilities: - Develop a Flink job using Java that can read parquet files from NFS. - Implement functionality to allow the selection of specific columns from the parquet files to be processed. - Ensure the selected data is published to a specified Kafka topic efficiently. - Manage dependencies and libraries required to execute the job without compatibility issues.
I'm in need of an Oracle expert with extensive knowledge in Exadata infrastructure. Coming into this project without any experience in the field, I am eagerly searching for someone who can guide me and transfer their knowledge, so I can gain a deeper understanding. - SKILLS REQUIRED: Extensive experience in Oracle Exadata Infrastructure, excellent communication skills, teaching/mentoring experience would be a bonus. - EXPECTED OUTCOMES: Teaching me the technicalities of Oracle Exadata Infrastructure, and making me feel at ease with managing and understanding this field. Specific topics to be covered would be discussed in further detail with the chosen freelancer. Ideally, these would cover resource management, operational tasks and data warehousing, but I am ...
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...
I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more
I need a fast turnaround to correct error messages in my PHP code and database. The main goal of my PHP application is to upload content to the database and ensure the site displays it correctly. Key Responsibilities: - Fixing error messages in PHP code - Addressing database issues - Ensuring smooth content uploading functionality - Ensuring the site can retrieve and display content from the database Ideal Skills and Experience: - Proficient in PHP - Strong understanding of database management - Prior experience in troubleshooting and fixing error messages - Ability to work fast and deliver under tight deadlines.
I'm looking for a task-oriented individual who can assist me with saving documents from an online database. Your assignment would primarily revolve around focusing on documents and seamlessly saving them off. Key responsibilities: - Download documents with my full permissions. - Make sure that all downloaded files are in audio file format and labelled correctly. The ideal candidate will have: - Relevant experience and proficiency in saving files to dropbox. - Excellent attention to detail ensuring the correct files are stored. May be 1-2 days of work.
MUST Read All DESCRIPTIONS! I'm seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Feel free to sch...
... and license usage. Non-functional Requirements: 1. Security: Implement HTTPS for secure communication. Apply role-based access controls to restrict unauthorized access to sensitive data. Regularly update and patch software components to address security vulnerabilities. 2. Performance: Ensure fast loading times and responsiveness of the website, even under heavy traffic. Optimize database queries and server-side processing for efficient performance. 3. Scalability: Design the system to handle a growing number of users and transactions over time. Employ cloud-based infrastructure to scale resources dynamically as needed. 4. Compatibility: Ensure compatibility with popular web browsers (e.g., Chrome, Firefox, Safari). Support responsive design for seamless u...
...crucial database issue with my website built on Node.js. There are certain missing tables that cause the application to crash whenever specific buttons are clicked on the site. Key Details: • The crashing issue is experienced when the Login button, Submit form button, or the Add to cart button is clicked. • Due to these unsolved errors, the terminal indicates that a certain table name is not found. Ideal Skills and Experience: • Solid background in solving database issues in Node.js platforms. • Experience in working with missing tables and rectifying database errors. Application Requirements: Freelancers interested in this project should include detailed descriptions of their previous and related experiences in their application. The ulti...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results....
I'm in need of a specialist in MongoDB who can effectively troubleshoot and resolve configuration errors that I've encountered during its reinstallation on my Ubuntu Apache server. I'd appreciate bids from candidates who, at a minimum, possess the following qualifications: - Expertise in MongoDB installation, setup, and troubleshooting - In-depth knowledge of Ubuntu Apache server management - Strong experience in handling configuration-related issues - Bonus: Understanding of file path, authorization, and networking issues, as the specific type of configuration error wasn't determined Please be ready to detail your relevant experience and strategies for resolution. Thanks!
I'm running a new PHP script on Linux and it's not pulling data correctly from an MSSQL Database. Since the script is new, I'd appreciate some help identifying what went wrong. Skillsets and Experience Needed: - Proficiency with PHP and MSSQL databases - Experience troubleshooting PHP script issues in a Linux environment - Experience with new script debugging - Knowledge of database connectivity issues and their solutions - Ability to communicate complex technical issues clearly
I'm looking for a skilled freelancer to assist with text data entry from online sources into a database. Key Responsibilities: - Inputting data from online sources into a database - Ensuring accuracy and consistency in data entry The ideal candidate should have: - Proven experience in data entry, particularly from online sources - Strong attention to detail to ensure accuracy - Proficiency in database entry methods This is a straightforward project that needs a reliable, detail-oriented individual.
I'm seeking a Laravel expert to help resolve a database connection error I'm experiencing on my website. This error occurs specifically when trying to access certain pages. Key requirements: - Experience with Laravel: You should have a strong understanding of Laravel's structure, especially concerning database connections, in order to diagnose and resolve this issue efficiently. - Troubleshooting Skills: You should be adept at identifying the root cause of the error, whether it be an issue with the code, configuration, or server setup. - Efficient Communication: As I have full access to the website's server and database configuration files, you may need to collaborate with me to access the necessary resources.
...issues with my Node.js site, I require an expert in database management to remap the database. Specifically, clicking on 4-5 specific buttons frequently crashes the site, displaying an error of "table not found". Understandably, this is impacting the usability and overall user experience of the website. The key project objectives include, but are not limited to: 1. Diagnosis and rectification of the error causing the site crash. 2. Remapping of the website database to eliminate the current recurring issue. 3. Arguably most vital, is the safe retainment and integration of the old member data within the newly rectified database. Ideal applicants should be proficient in Node.js and database management, especially handling and rectifying such ...
I'm in need of a skilled .NET developer to create a functional web application that mainly handles user registration, login, and database management. Key Requirements: - User Registration and Login: The application should have a robust system for users to sign up, log in, and manage their accounts securely. - Database Management: Proficient database management within the application is a must. This includes data storage, retrieval, and manipulation. Additional Information: - External Integrations: There is a possibility that additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While th...
I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financ...
I am looking for a skilled graphic designer to create an effective and eye-catching roll-up banner for my company's booth at a conference. Your design should incorporate the following elements: - Company logo a...- Ability to creatively combine text and graphics to communicate key information. - Experience in designing banners or similar promotional materials. Your understanding of color theory and ability to create a standout design that readily communicates our business offering will be critical for this project. Please incorporate these sentences in the design: Title: Oracle automation and mobility made easy. Subtext: Your Oracle system is complex, your modernization journey doesn’t have to be. Generate API's of your EBS customizations using AuraPlay...
...triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project should have: - Extensive experience with Apex Oracle application dev...
I'm in need of a professional who can help me with installing the Oracle 23c database on my Ubuntu Linux system. Key Skills: - Proficiency in Oracle database installation - Specific experience with Oracle 23c - Strong understanding of Ubuntu Linux The selected candidate should be able to: - Perform a detailed installation of Oracle 23c database (enterprise version) on Ubuntu Linux - Ensure proper configuration to meet the project's requirements - Provide guidance on any post-installation tasks that may be necessary Is there any possibility to install a 23c oracle database enterprise version not free version on docker?
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. As far...
I'm in need of a skilled freelancer to help me with a specific task. Here's what you need to know: - The task primarily involves installing a Cloudflare certificate on a CentOS server running Apache. It's crucial to have a good understanding of both Apache and CentOS to successfully complete this task. - Having root access is essential, as it's required for the installation process. - I currently do not have any SSL/TLS installed on my server. The task specifically involves installing a Cloudflare certificate. Ideal skills for this job include: - Strong proficiency in Apache - Experience with CentOS - Prior experience installing Cloudflare certificates - Good knowledge of SSL/TLS protocols and practices - Ability to work with root access on se...
Please read before offering services - I am in need of a highly skilled and reliable SEO specialist who is familiar with the nuances of the APACHE, LINLUX & UBUNTU platform. The website is located DIRECTLY ON SERVER, NOT USING C-PANEL, as c-panel does not work on Ubuntu 18/20.04 You must also be familiar with HMTL5 and TPL & LINLUX You MUST have previous experience and knowledge in APACHE, LINLUX & UBUNTU OS Freelancers interested in this project should have extensive experience working with open-source operating systems and in-depth knowledge of cutting-edge SEO strategies. To be considered for this job, please include samples of your past work in your application. I'm eager to see evidence of your expertise and results you've achieved for previ...
I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.
We are currently facing an urgent requirement for the implementation of Oracle SCM/demand planning modules. We are in search of SCP experts or IT consultancy partner companies with proven experience in SCM/demand planning module implementation in Oracle EBS R12. The scope of work will cover the following aspects within Oracle SCM EB R12: Predictive Analysis based on MRP Demand forecasting for peak and off seasons Demand Sensing Multi-Dimensional Analysis: Analyze demand by product, customer, region, channel, and other relevant dimensions for deeper insights and better decision-making Supply chain integration Forecast accuracy tracking Reporting and Analytics
I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen unders...
I'm seeking an experienced professional to perform a data migration from Oracle to Snowflake.
I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.
I'm looking for an expert in Linux administration who is specialized in server setup. My project requires: - Setting up a LAMP on a Ubuntu server with MariaDB. - Configuring the server to respond to a specific domain name, empty folder mapping. - FTP and account mapping to the webserver's folder. Necessary skills: Ubuntu, LAMP setup (Linux, Apache, MySQL, PHP), FTP setup. Experience in managing and setting up servers is a must. This are a very easy setup so maximum 2 hours. Please add the word "Light" in your quote so I now you are not a bot...
I am in need of a professional who can help me with my social media marketing campaign, focusing on increasing brand awareness, driving website traffic, and generating leads and sales. The ideal candidate should also have a background in website design and optimization, and be skilled in vide...and sales - Proficiency in website design and optimization, particularly for business websites - Strong video editing and graphics design skills - Understanding of the Spiritual Space as well as Social media Marketing trends & hacks TikTok, Instagram, Youtube, Twitter, Facebook If you have the right skills and experience to handle this project, and an interest in Healing (Energy Healing, Tarot/Oracle Reading, Akashic/Past Life Healing) Job is Monthly I would love to hear from you. Than...
I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all...
I need a professional to help me resolve an Apache ModSec error that is preventing a specific theme inside WordPress from working properly. Key Requirements: - The problem I'm encountering is related to ModSec, and is preventing the theme from functioning as expected. As such, the freelancer should have a good understanding of ModSec and Apache, with a specific focus on troubleshooting and fixing errors. - The error message is not provided here, but the last change I made to the website was modifying server or ModSec settings. The freelancer should be able to work with me to understand the changes made and identify the cause of the error. Expectations: - I am specifically looking for someone who can troubleshoot and fix the ModSec error, rather than just disabling Mod...
I am in need of a skilled professional to assist me in setting up my almalinux 8 VPS and then installing cPanel on it. Specifically, I would like to have the following services installed and configured as part of the initial server setup: - Apache - MySQL - PHP It's essential for the freelancer to have experience in setting up VPS servers, particularly with a specialization in almalinux 8. You will also need to have a thorough understanding and experience with cPanel installation.
I'm in need of a skilled Apache Superset expert who can help me connect MySQL and PostgreSQL to the platform for exploration and visualization. Key tasks include: - Creating interactive dashboards - Generating real-time reports - Building visualizations for large datasets Features & functionalities needed in the deliverables: - Filter and drill-down options - Customizable charts and graphs - Integration with external APIs Ideal candidates should have: - Extensive experience with Apache Superset - Proven track record of working with MySQL and PostgreSQL - Strong background in data exploration and visualization - Demonstrable skill in creating interactive dashboards and real-time reports - Familiarity with building visualizations for large datasets - Ability to int...
I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design w...
I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus....
...specifics of the data extraction are as follows: - I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filters and run them on pocketbase server side routes, so that they can be used to feed data to views. (...
...skilled Oracle Apex developer who can help me enhance my existing Oracle Apex app. Key Requirements: - User Interface Redesign: The app needs a fresh new look to make it more user-friendly and visually appealing. - Database Restructuring: There's a need for some changes in the database structure to optimize performance and better suit the app's functionality. - Implementing New Features: I'm interested in adding some new functionalities to the app to improve its overall utility. Timeline: I'm aiming to have the enhancements completed within a month, so I need a developer who can work efficiently and effectively. Ideal Skills and Experience: - Proven experience with Oracle Apex development and enhancement projects. - Strong UI/U...
I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince ...
