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 (모바일웹, 앱) 기술 우대
...compelling content, design eye-catching packaging, build a user-friendly website, manage social media channels, and implement data-driven marketing tactics. Desired Qualifications Proven experience developing and launching social media campaigns for health & wellness brands. Solid understanding of current superfood trends and target audience. Exceptional content creation skills in writing engaging copy, crafting stunning visuals (photos and graphics), and potentially creating video content. Website development proficiency (WordPress or similar platform experience preferred). Strong marketing knowledge, including SEO principles and basic data analysis. Packaging design experience with a focus on health food products (portfolio required). Excellent communication and organisat...
...need of a skilled computer expert to help me develop a database. This database will essentially serve as an accounting tool for food. It's crucial for me to keep track of various aspects of my food-related transactions, including purchases, sales, and expenses. I require a professional who can translate these needs into a well-structured database. Key requirements include: - Data on food purchases, sales, and expenses should be efficiently stored and easily accessible - The database should be designed to facilitate clear accounting procedures - The system should be user-friendly and reliable, making it easy for me to input data and generate reports as needed Ideal skills and experience for this project are: - Proficient in database design, part...
...into various file formats. Requirements: - I already have the logo, I just need it converted into PSD, JPG and PNG file formats. - The logo will be used for printing on shirts, so it's important to ensure that the converted files are high-quality and suitable for this purpose. Preferences: - I have specific color preferences for the logo and would like the designer to match the colors to the copy sent. - The font and typography used in the logo are the same as the image I've sent, please ensure this is kept consistent when converting to the different file formats. Ideal Skills: - Proficiency in graphic design and editing software - Experience in logo design and file conversion - Attention to detail to ensure colors and typography match the original Looking for a d...
I'm expe...the front end - High server CPU usage, which I suspect is leading to the slow loading times - Database connection errors - Posts in the backend are taking a considerable amount of time to load I haven't made any recent changes to the site, such as installing new plugins or updating the theme, which could have caused these issues. I need a skilled professional who can dig into these issues and improve the overall performance of my site. Ideal skills and experience for this job include: - Extensive experience with WordPress - Proficiency in optimizing site performance - Knowledge of Apache and MySQL/Mariadb - Experience working with Virtual Private Servers - Ability to diagnose and resolve database connection errors - Understanding of server CPU ...
...errors in the PFD. There may be places where different symbols are used or improperly labeled. Ensure that these are fixed in the P&ID and all symbols and labels are consistent. - Add insulation specs and piping labels as necessary. You might see notes like "2" CS" or "1/4" SS". You need to create proper piping specs and labels. CS, SS, and PVC are piping materials. - We do NOT expect you to simply copy the exact symbols and layout of the PFD. We expect you to interpret the PFD and put everything in proper format and style for P&IDs. Workflow: 1. Use HYSYS simulation software to verify the specifications of the pipes (double jackets) and pumps provided. 2. Upload the P&ID in DWG format as it is completed, not at the last minute. 3. We ex...
As a business owner with an existing website, I'm searching for an expert in Amazon Web Services (AWS), PHP, MySQL, and server administration. My core objective is to seamlessly migrate my website to AWS. Your role would involve: - Setting up and managing EC2 instances. - Assisting with RDS database and S3 storage. - Implementing Elastic Beanstalk. Necessary Skills include: - Extensive experience with AWS (EC2, S3, RDS, Elastic Beanstalk) - Website migration expertise - Strong background in PHP programming - Familiarity with MySQL - Proven Server administration skills Please bid with relevant credentials and explain how you would ensure a smooth migration.
...with our Oracle database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability and reliability ...
I'm looking to develop a landing page with the primary goal of capturing leads from businesses. Key Requirements: - **Lead Generation Focus*...require an overwhelming amount of information from the user. Ideal Freelancer: - **Experience in Landing Page Design**: You should be well-versed in creating landing pages that are optimized for lead generation. - **Understanding of B2B Marketing**: Knowledge of strategies and techniques that are effective in a business-to-business context. - **Copywriting Skills**: Ability to craft compelling copy that will resonate with a business audience. - **UI/UX Design Skills**: An eye for design and experience in creating user-friendly interfaces. If you have experience in creating lead generation landing pages for B2B audiences, I'd lo...
I am in need a letter of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new busines...Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new business, the type of business, and anticipated date of opening. I called the show and they said that a digital copy is fin...
I am in need of an experienced Visual C# developer with expertise in User Interface (UI) design and database integration. The ideal freelancer for this project should have: - Proven experience in Visual C# programming - Ability to create a clean and minimalist user interface. - Proficiency in database integration, specifically with handling user data and profiles. Main tasks and features include: - Developing an intuitive and minimalist UI using Visual C#, to ensure easy navigation and optimal user experience. - Integrating the system with a database that handles user data and profiles. This includes setting up, managing, and maintaining the database to ensure its smooth operation. This project requires a successful blend of programming skills and a keen eye...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the e...on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of code efficiency, performance, and quality. - Previous work on developing completion scopes for s...
I am looking for an experienced and reliable PHP developer to integrate a new payment provider (CCBill) into our existing ecosystem. This system includes various APIs built with PHP 7.4, Symfony and MySQL. Requirements: - Extensive experience with PHP, specifically PHP 7.4 - Familiarity with integrating payment providers - Experience working with Symfony framework - Experience with MySQL databases - Familiarity with complex API ecosystems - Reliability and professionalism Project Details: - Scope: Integrate a new payment provider into our existing system, ensuring seamless functionality - Timeline: Expected duration and deadline can be discussed - Communication: Regular updates via preferred communication channels (email, zoom or skype) Budget: To be discussed ba...
ONLY RESPOND IF YOU CAN WORK ON THIS NOW. I urgently need assistance with my potentially damaged Microsoft Exchange 2016 database. I'm not sure if it's damaged, but I'd like an expert to mount it.
I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL database that requires c...
I have a set of handwritten documents that are moderately clear and need to be typed out without any changes in the format. I am looking for an experienced typist or data entry specialist for this project. The successful candidate should: - Have a strong proficiency in English - Be able to decipher moderately clear handwriting - Be patient and detail-oriented The task is to accurately transcribe the content of the handwritten pages into a digital document, without any alterations in the layout. Your responsibility is to provide me with a neatly typed, error-free version of the original handwritten text. Please note that the quality of the output will be checked against the original, hence, accuracy is paramount.
...Solid understanding of modern and minimalist design principles - Expertise in creating print-ready graphics - Proven background in voucher or similar promotional design material. Task Details: - Design a print voucher in a modern, minimalist style - Ensure design is suitable and optimized for high-quality print usage - Collaborate closely to align with existing brand guidelines I don't have soft copy ....
...a logo for my company, Luminous Properties. As a land and property developer, it's crucial that the final design conveys trust and reliability. we care about environment and natural beauty, so we also like to have something that shows this on our logo. We want to have an icon that represent us and our name on our logo. Please submit your unique design, we will reject any auto generated logo or copy of other's concept. The ideal candidate should have: - A solid understanding of logo design, particularly in the context of property development. - Proven experience in creating logos that communicate trust and reliability. - A keen eye for aesthetics and detail. - The ability to bring innovative and fresh ideas to the table. - Strong communication skills to understand and ...
I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tree format.
I am starting a business that specializes in professional copywriting services and engaging PowerPoint presentation designs. To achieve my business goals, I am seeking to asse...keyword optimization to enhance online visibility of written content. - Proficiency in editing and proofreading to ensure high-quality, error-free deliverables. - Experience in online marketing to help strategize content that aligns with brand identity and marketing goals. The ideal candidates will be creative, detail-oriented, and have a proven track record of delivering professional and effective copy and designs. This team will be crucial in establishing a strong foundation for my business services, catering to diverse client needs, and helping to set a high standard for quality and engagement in our del...
I am looking for help building my landing page design wordpress site. I have purchased the domain and theme plug-in (envato travel tour) but i need help installing it, and editing the home page. Then I need help editing a template for a tour page, where I can copy it and create similar other tour pages, along with a contact page and FAQ page after. I also need help installing a plug in where the site is GEO-blocked from Mexico and the US, along with yoast seo and maybe others.
I'm in need of a skilled and experienced draftsman who can help me draft floor plans, elevations, and sections for a small residential house of less than 200sqm. I have a full set of plans already i just need someone to redraw them on a different title block and make some changes to the windows for me. It's only changes to 3 w...the windows for me. It's only changes to 3 windows and adding a door to the garage. very simple If we work together well then i am hoping to go in to more detailed bathroom and kitchen plans. Ideally, I'm looking for a freelancer who can translate my vision into accurate and construction-ready plans. Please only bid if you have a portfolio in residential house drafting. I would also like a copy of the revit file so I can make my own ...
Convert 2 page brochure from PDF to AI files. Recreate source files from PDF for easy editing. Create a layer from each section. Copy the text from each section. i.e. each image is a layer, each text block is a layer, each text heading is a layer For reference-page1 should contain approximately 19 layers.
I need a detail-oriented freelancer to help me transfer data from various PDF files. Key Responsibilities: - Copy and paste data from PDF files to other formats. - Ensure data integrity and accuracy. - Work efficiently without compromising quality. Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints Looking forward to your proposals.
보다 자세한 내용을 확인하시려면, 회원 가입 또는 로그인 절차가 필요합니다.
I'm in need of a copywriting specialist to execute beautifully worded writing tas...need of a copywriting specialist to execute beautifully worded writing tasks centred around Health & Lifestyle. Key roles include: - Creating engaging and informative copy centred on Health and Lifestyle topics. - Rewrite and enhance existing copy to better fit the industry's language and themes. Ideal Skills: - Excellent command of English - Prior experience in Health & Lifestyle copywriting - Creativity in capturing audience's attention - Strong understanding of health and lifestyle industry standards and language. This project requires a keen eye for detail and an innovative mind to deliver compelling and impactful copy. Please only bid if you believe ...
I am in need of a skilled freelancer who can help me extract all products from an online shop and import them into my Shopify store with all details and options. Key Responsibilities: - Extracting all products from an existing online shop - Importing/copying these products into my Shopify store I expect the freelancer to: - Ensure all product information is correctly ported over like variants...Maintain the quality of product listings - Ensure the product images are not lost during the import I'm looking to work with someone who has: - Experience with product extraction and import in shopify - Proficiency in Shopify - Attention to detail Please provide a timeline for completion when bidding. Please check the size of the shop and the number of products ()~ 8.000 Products) you need ...
...animating a dot left and right on the screen. Here are the key details and requirements: Key Features: - Animation of a simple dot moving left and right on the screen - Integration with Zoom API for seamless operation in Zoom - Capability to control the speed of the dot's movement - Feature enabling the dot to be superimposed over the video of the therapist or provide a background image. You can copy the basic function of this website. (click the link that says, 'use the basic version for free'. Design Preferences: - The moving dot should be a simple, unembellished design but option to change colour and size. Ideal Skills: - Proficiency in app development, particularly for Zoom - Prior experience with EMDR therapy or similar mental health applications will be...
...creating product descriptions that not only inform but also persuade professionals to make a purchase. - Understand and cater to a professional audience: The language and tone of the content should resonate with professionals. It's essential that you have a good understanding of what would appeal to this demographic. - Drive sales: The end goal here is to contribute to an increase in sales through your copy. Your descriptions should be able to convert readers into buyers. Ideal skills and experience: - Proven experience in writing product descriptions: It's important that you have a track record of writing product descriptions that have led to increased sales. - Understanding of the professional audience: A good grasp of what appeals to professionals and an ability to ...
...Stripe, PayPal). • Implement APIs to handle payment transactions, process payments, and manage payment statuses. 3. Document Management: • API for users to upload documents. • Secure storage of documents. • API for admins to update the status of submissions. 4. WhatsApp Integration: • Integrate a WhatsApp Business API. • Implement APIs to handle user inquiries and provide automated responses. 5. Database: • Design a schema for storing user data, submission details, payment transactions, and status tracking. • Tables: Users, Submissions, Payments, Statuses, Chat Logs • Ensure data integrity and security. Main Integrations 1. User Registration and Authentication: • Enable users to create accounts and securely log in. 2. Payment Gate...
I'm looking for an exhaustive list of Australian gym owners, with a focus on capturing between 100 to 500 individual records. The data needed includes, but not limited to: - Owner's Email Address - Gym's Name - Gym's Website Ideal candidates for this job are experienced data miners and researchers. Having a good understanding of the Fitness industry would be beneficial. Strong attention to detail is paramount, ensuring accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Category - Fitness Equipment Category - Community He...
...understanding of the importance of a well-designed website and the value it brings to a business. • Tech Savvy: Familiarity with basic website design concepts and digital marketing trends is a plus. Technical Requirement: • Fast Internet • American English Accent • Quality Microphone Ready to take your sales career to the next level? We are! How to Apply? (Do the Following to be considered, copy and paste the template below and use as your cover letter) 1. Record Your Voice: Read the following sales script with your voice: 2. Speed Test Goto: Change server to any Los Angeles, CA Server. Screenshot or link me to
...This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal skills and experience for the job: - Proficiency in Laravel and PHP - Experience with database setup...
...begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. Please provide your past experience and any relevant...
I'm searching for a proficient mail developer who can accomplish the following tasks: - Write engaging email copy. - Create a Zimbra mailer using either SOAP API or EWS. You must have experience with all mentioned platforms, namely Zimbra, SOAP API, and EWS (Exchange Web Services). The developed Zimbra mailer needs to have the functionality to send emails. Kindly bid if you have the necessary skills and experience. Look forward to working with professionals in this area.
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record in creating high-perfo...
...addressed. The app is crashing on startup and experiencing database retrieval issues. Your task would be to resolve these errors and make the application functional again. - Database Update: You'll need to shift from the current WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interactive elements. Ideal skills for this project: - Proficiency in React Native development - Experience with database manage...
I am looking for a freelancer who can help me with simple copy-paste tasks for my website. Key Responsibilities: - Copying text content from various sources and pasting them onto the website - Ensuring correct placement of the text within the website's structure Ideal Skills and Experience: - Proficiency in basic web browsing and text editing - Attention to detail for precise copying and pasting - Prior experience with content management systems (CMS) is a plus, but not required This is a straightforward job that doesn't require any formatting skills, just the ability to accurately copy and paste. The selected freelancer can expect ongoing work based on performance. Here is walkthrough of task. We expect 2-3 Lessons per hour on average for fulltime work.
...specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience workin...
I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.
I'm in need of a skilled and experienced draftsman who can help me draft floor plans, elevations, and sections for a small residential house of less than 200sqm. I have a full set of plans already i just need someone to redraw them on a different title block and make some changes to the windows for me. It's only changes to 3 w...the windows for me. It's only changes to 3 windows and adding a door to the garage. very simple If we work together well then i am hoping to go in to more detailed bathroom and kitchen plans. Ideally, I'm looking for a freelancer who can translate my vision into accurate and construction-ready plans. Please only bid if you have a portfolio in residential house drafting. I would also like a copy of the revit file so I can make my own ...
• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related...
Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.
• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related...
