The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...주문내용(총금액, 건수, 미배송건수)을 보여주려 합니다. Eclipse 소스를 원합니다. 달력은 월별로 이동이 되어야 하고, 현재일자는 배경색을 달리해서 표시가 되어야 합니다. 주문이 없는 날은 표시가 안 되면 됩니다. 일자를 선택하면 그 날 주문한 상품의 이름,수량이 보였으면 합니다. 주문상세내용이 보였으면 합니다. 그리고, 원격 Database 접속정보와 관련된 쿼리는 아래와 같습니다. OS는 windows 2012 , 데이터베이스는 MS-sql이고, 원격주소, 계정, 암호는 실제 내용을 알려드릴 수 없는 점 양해바랍니다. 현재 디비접속은 이런 형식으로 하고 있습니다. -> ,1000 (사이트주소,포트번호) , 계정 : Testaccount , 암호 : Test 입니다. 금액 쿼리 : Select replace(convert(varchar, cast(Isnull(Sum(Ori_price*qty),0) as money),1),'.00','') as Orderamt from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 금액은 붉은 색 글씨로 표시되었으면 합니다. 주문 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN=&#...
Are you a wizard of website design, ready to work your magic on a specific target platform? We're on the lookout for a skilled individual to optimize and elevate our chosen website, taking it from good to exceptional. What We Have: Target Website: We've selected a specific website as our target for optimization and enhancement. Your task will be to analyze its structure, identify areas for improvement, and implement upgrades to elevate its performance. Base for Development: You'll be provided with our chosen website as a base for your development. This will serve as the foundation for your optimizations and enhancements. What Needs Enhancement: Optimization: Our website has potential, but it needs fine-tuning to reach its full glo...
...designers to help us create a logo that is both modern and meaningful, reflecting our core mission of providing insightful analytics solutions. About : specializes in transforming complex data into actionable insights. Our services cater to businesses of all sizes, helping them make data-driven decisions with precision and ease. The logo should embody themes of clarity, intelligence, and innovation. Design Requirements: The logo must include the icon that can stand alone. We prefer a clean, modern look with minimal colors. The design should be scalable and look good in both color and black and white. Please avoid overly complex designs; we value simplicity and clarity. Color Preferences: We are open to suggestions but lean towards our website (https://6634a8
I'm in need of a skilled web designer to create a unique and user-friendly website aimed at vendor matching. The primary objective of this website is to facilitate direct contact between users and vendors. Key Points: - **Design Focus**: The website should be designed with vendor matching as its central theme. This means that the design should be intuitive, easy to navigate, and visually appealing. - **Vendor Criteria**: The criteria for matching vendors will be based on their industry expertise and the speed with which they can deliver their services. Therefore, the website should be able to present this information in a clear and concise manner. - **User Interaction**: The main flow of the website will involve users directly contact...
As a website owner, I've been receiving SEO warnings on SEMrush tool – particularly related to mobile optimization, page speed, and broken links. These are critical issues to address as they are impacting my search engine ranking. I'm looking for an experienced SEO specialist who can help me fix these warnings. Key Responsibilities: - Analyze and understand SEMrush warning reports - Address mobile optimization issues - Improve page loading speed - Resolve broken links Ideal Skills and Experience: - Proven experience in SEO and SEMrush - Expertise in mobile optimization and page speed improvement - Ability to effectively fix broken links - Strong track record in improving website ranking through addressing SEO warnings
...phrases that potential customers are using to search for products or services. On-Page Optimization: Optimizing website content, including meta tags, headings, images, and URLs, to make them more search engine friendly and improve rankings for target keywords. Execute Content Strategy: Developing a content strategy that aligns with SEO goals, creating high-quality, engaging content optimized for search engines and user experience. Link Building: Building a network of high-quality backlinks from reputable websites to improve domain authority and rankings. Technical SEO: Identifying and fixing technical issues that may impact search engine crawling and indexing, such as site speed, mobile-friendliness, and site structure. Monitoring and Reporting: Tracking key SEO metrics li...
I need a talented designer who can create an abstract, icon-based logo for my company. The logo should feature an object, depicted in an abstract style. This requires an imaginative mind and the ability to translate ideas into engaging visual content. Previous experience in creating abstract, icon-based logos is a plus. You need to have excellent communication skills to understand my requirements and feedback, and turn them into a logo that fulfils my vision. Please include any relevant previous work in your proposal.
I have a medium-sized data entry task that involves entering data from typed documents. The volume of data...task that involves entering data from typed documents. The volume of data is between 100 - 1,000 records. Ideal candidates for this project should have the following skills: - Proficiency in data entry. - Attention to detail. - Excellent organizational skills. - Efficient and accurate typing ability. The work will require you to: - Enter the data accurately while maintaining a high level of speed. - Organize and manage the data effectively. - Ensure that the data is entered correctly and is ready for further processing. I'm looking for a reliable and efficient freelancer to help with this project. Please provide a brief overview of your experience with similar task...
I need a proficient freelancer to establish integration of the Square payment system with my WordPress website. - SKILL SET REQUIRED: - Excellent knowledge of WordPress and its plugins - Experience with the Square payment system setup and integration - RELATING TO SQUARE: I already have an existing Square account and aim to utilize it for transactions on the WordPress site. - KEY RESPONSIBILITIES: - Implement the Square payment system to the website - Ensure seamless transactions are possible - Test the final setup to confirm functionality Please note, I have not specified any particular features or functionalities for the plugin. The freelancer will need to advise on this based on professional understanding and past experience. Input in this...
I am seeking an experienced Django developer who can design a fast-operating framework with high-grade security features. The major areas of focus in this job will include: 1. User authentication and robust data modeling and database integration. 2. API development for encryption and decryption activities. 3. Architecture designed for speed, this includes fast page load times, quick response to user interactions, and high data processing speed. 4. Advanced security measures that include encryption of Private Messages (PMs) and attachments. The PM recipient should be able to log on to the site to read these. 5. A tracking system to monitor all user logins, including capturing images during logins and transactions with the help of facial recognition software. 6. Ensuring no ...
I need a skilled web des...designer who can help mold my website. The experience and skills you bring to the table should should be available for virtual meetings before I decide upon you. - Photoshop expertise: You'll be instrumental in curating and modifying visuals that make a statement. Demonstrated experience with Photoshop is mandatory. - Profound knowledge of UI/UX design: This website is all about user experience and intuitive utility. I'm looking specifically for someone who has a significant background in UI/UX design. - Mastery of responsive design: As this website is targeted at the youth population, a fully responsive design that accommodates all device types and screen sizes is a must. With your skills and creativity, we aim to do changes wit...
Hi We would like to update our website and make an app and also do the SEO for our website. Please get back to us with prices and realistic timescales. Thanks
Check existing config. Create VLANs, IDs and name tag based on the existing design. Configure and test Device. Then move onto the next VLAN and so on. Both Console and Web interface available. Trunk Ports required for new APs. Switches will include Stackable Sg350x. I also have a number of HP Procurves but not to worry if these are not possible.
...user interface to control inputs such as speed, run time, and positioning of each motor. - Ensure smooth synchronized movement between the 3 motors. Each motor has a 300:1 gearbox and will drive a very slow moving assembly. I would like to use micro stepping to further slowdown the movement. For this task, the ideal candidate should be proficient in the following skill set: - Solid understanding of Raspberry Pi programming. - Extensive experience with bipolar stepper motor control. Control of the Raspberry Pi should be done remotely via a phone. The user interface can be very simple, with inputs that allow each motor's speed, and start/end points to be set. When the program is running, I'd like the user interface to display the position and speed of eac...
I am looking for a freelancer to assist me with a typing project. The project involves typing more than 100 pages of PDF documents. Requirements: - Proficient in typing and attention to detail - Ability...typing and attention to detail - Ability to follow instructions and work independently - Experience with typing PDF documents is preferred but not required Specifics: - The documents do not require any specific formatting and can be typed in any standard format. - The freelancer has the freedom to choose the most suitable formatting for the documents. Skills and Experience: - Excellent typing speed and accuracy - Strong attention to detail - Ability to work independently and meet deadlines Please provide a sample of your previous typing work. Thank you for your interest in thi...
I'm looking for someone who has experience with the Etsy platform. so I will need to warm up the seller's account and upload the products and description.
...existing system, built using Flutter for the User App, the Partner App, and React for the Management Dashboard, the Partner WebApp and Website. The system components include: - User App (Flutter) - Partner App (Flutter) - Partner WebApp (React) - Management Dashboard (React) - Website (React) The core development is already completed. The tasks remaining are as follows: - Complete the points listed in the Google Sheets for each module (total of 7 sheets) - Implement remaining functions as specified in our documentation folder - Address any existing bugs - Improve all API's, loading issues (we're looking to enhance the system's performance, focusing on speed and loading times.) - Establish GitFlow structure across the system in our GitLab reposito...
...the sharepoint will have public website and also will be used for internal emplyee The Requirements : - Ease and flexibility of use by the site administration. - A comprehensive control panel for dynamic content management. - Multiple authority levels (manager, editor, publisher, etc.). - An easy and integrated system for managing multimedia (images, video, etc.). - Flexible tools for publishers enabling review and scheduling. - Compatibility with C3W standards for cross-browser functionality. - Possibility of future development without impacting existing content. - An excellent, search engine-friendly system for periodic archiving of content (SEO). - Multilingual support (Arabic - English). - Design meeting standards for speed and ease of b...
...starting point will be to provide a defined list of authors, along with the Excel spreadsheet template that sets out the required fields to be researched and populated, to Freelancers that meet the above criteria. We are planning for an initial paid trial that would be based on an agreed hourly rate for a 2 or 3 hour period (spread over several days), after which an assessment will be made as to the speed, accuracy and thoroughness of the work, and prospects for ongoing engagement. We’re not looking for the lowest hourly rate - but instead the engagement of a Freelancer who meets the criteria, understands our objectives, and can produce quality results in a cost efficient manner. The objective of the paid trial will be to establish a fair and reasonable (and mutually ...
I am seeking a skilled professional to improve my website's performance. While specifics are yet to be outlined, the key focus lies in enhancing the overall performance. An ideal candidate should have: - ...improve my website's performance. While specifics are yet to be outlined, the key focus lies in enhancing the overall performance. An ideal candidate should have: - Proficiency in web performance best practices. - Extensive background in website optimization. - Excellent problem-solving skills. Being able to work unsupervised while identifying key areas for improvement is crucial. As details were not provided on whether speed, user flow, mobile optimization, or specific pages need more focus, I encourage freelancers with a broad set of skills in website...
Urgent Loocking one program for change voice in live call / Need this program working on windows for softphone (zoiper ,xlite , eyes beam ) Its will be for call center ! Sip Agent need to change his her voice immediatly and voice must be natural . Girl to man /man to girl Im pay direct 30 usd who find me this program . And propose direct on test .
The goal of this project is using Vivado tools to enable a hardware implementation on an FPGA board. The key requirement from the FPGA board is high computational speed. Therefore, proficiency in Verilog language is preferred as I intend to implement the NTT algorithm. I am looking for a developer who is experienced with FPGA boards and Vivado tools. The chosen freelancer should also have the ability to maximize computing capabilities of the board for the said implementation.
I am in search of a talented designer to create a modern logo for my new business venture. While I don't have a specific vision in mind, I am looking for something that is sleek, current, and can stand the test of time. Ideal Skills and Experience: - Previous experience in logo design, particularly with a modern aesthetic - A strong portfolio showcasing your ability to create unique and memorable designs - Excellent understanding of color theory, typography, and visual balance - Good communication skills to understand my vision and translate it into a design
I need a backend api (or program) that running on java or .net that can send messages via facebook messenger (do not use Facebook APIs) using Selenium or other automation frameworks you are familiar with (if you use other automation frameworks, you must notify me for confirmation). Key features: 1. Log in with the provided the user/password. 2. Send messages to specific Facebook users with provided information. 3. Send Messages from more than 2 senders to specified receiver in a short time. 4. Receive messages from Facebook users in real time (can get username information, message content). 5. Facebook will not block messages for spam reasons (the limitation is defined by you). Must-have skills: Java (familiar with Spring Boot) or C# programming skills (familiar with .Net core) Nice to hav...
Seeking a server specialist familiar with handling tasks on a dedicated server, predominantly Linux Server The tasks include: - Expertly masking or hiding the server's backend IP from the public view. - Seamless integration of the server with Cloudflare. - Closing off all u...the server's backend IP from the public view. - Seamless integration of the server with Cloudflare. - Closing off all unnecessary or unused ports to enhance cybersecurity measures. For this project, you should possess a deep understanding of server administration, Linux operating systems, and Apache web server. Familiarity with Cloudflare or similar web infrastructure and website security services is a must. Speed, efficiency, and an eye for detail will be key elements for this ta...
I'm in need of a skilled freelancer who can efficiently collect text and multimedia data from a website, as well as translate images from Chinese to Russian with accuracy and speed. Key responsibilities include: - Extracting text and multimedia information of 2000 products from the selected website. - Translating Chinese text in images into Russian. The ideal candidate would: - Be fluent in Chinese and Russian. - Have experience with data entry tasks. - Have a sharp attention to detail. - Be able to work under tight deadlines, as I require this project to be completed ASAP. If you have the right skills and the ability to deliver on time, I would be glad to work with you. Please bid after considering these details.
**Logo Design and Business Card Request for SinglesMix and Brickell Singles Mix** **Project Overview:** I am seeking a talented logo designer to create two sophisticated logos along with matching business card designs for my website, SinglesMix, and its local edition, Brickell Singles Mix. The logos and business cards should have an elegant and refined look, with a focus on timeless design and a sense of connection and exclusivity. **Logo Specifications for Singles Mix and Brickell Singles Mix:** - **Name Variations:** THESE ARE 2 DIFFERENT DESIGNS. PLEASE DO NOT PUT SINGLESMIX with BRICKELL SINGLES MIX BELOW IT - For SinglesMix: Singles Mix / SINGLES MIX / SINGLESMIX / singlesmix / singles mix - For Brickell Singles Mix: Brickell Singles Mix (This will use the s...
I am in need of assistance modifying the squid proxy server for , specifically focusing on improving the network latency. This project aims to enhance server performance during T...specifically focusing on improving the network latency. This project aims to enhance server performance during Tatkal ticket booking by allowing faster response times. Required Skills and Experience: -Intermediate level knowledge in Squid proxy server modification and optimization. - Proven experience in improving network latency. - An understanding of high-traffic websites and how to optimize for speed and efficiency under such conditions is critical. Application Requirements: Please include your relevant experience in network latency improvement and Squid proxy server optimization upon application.
Hello, i have an image that has a special style, now i need you to create a similar image as vector with another motiv with SAME COLORS and SIMILAR Style, so i have a series of two that seems to be from same painter painted as a series of images. Details and original Image comes by message
Hi, I am looking for WordPress Website Expert to speed up my current website.
Just a small 3 tables work, (Image, name and amount). API to pass the value
I'm looking for someone with significant experience in implementing advanced algorithms in computer science. The main goal of this project is to improve problem-solving efficiency with the use of data structures. Key Tasks: - Analyze current algorithms to identify areas for optimization - Implement advanced data structures aimed at problem-solving optimization - Test and adjust where necessary to ensure maximum memory efficiency Ideal Skills: - Strong knowledge and experience in advanced computer science algorithms - Proven track record of utilizing data structures for problem-solving - Excellent ability to analyze data and optimize memory usage Successful completion of this project demands a deep understanding of advanced computer science algorithms and the ability to prof...
I need a skilled MERN stack developer who can convert a page my previous developers created in Reactjs. I will be integrating this page to my website so if you work good, you can get that project too. This page is hosted so you will be creating by yourself Page to be linked should be
I'm seeking a proficient video creator who has a knack for making impactful educational content. The task at hand is to craft training videos specializing in the IT domain - highlighting intricacies of navigating a novel technology product. The target audience for these are both novel employees and existing ones who aspire to upskill. Expectations include: - Crafting technically accurate yet comprehensible content - A focus on how-to elements related to an IT product - Ability to intuitively articulate operations and best practices Ideal Skills: - Expertise in video production, specifically training/educational content - Background or familiarity with Information Technology - Proficiency in simplifying complex technical concepts. See the following link to know the kind of Videos I...
I am interested in a monetized quiz app for relationships similar to based on quiz which gives results based summary based on archetype or personality traits. Another example is manifest app
...2ae7a27af970 Project Overview: - is seeking proposals for the development of a new eCommerce website based on the WordPress Astra theme and WooCommerce. This website will serve as our primary platform for selling website templates sourced from We require integration with Stripe for credit card processing. Project Scope: Website Development: - Develop a fully functional eCommerce website using WordPress, the Astra theme, and WooCommerce. - The website should be optimized for performance, mobile-friendly, and SEO-ready. Template Integration: - Integrate website templates from Astra's collection (), ensuring they are displayed appealingly and functionally on our platform. - Payment Gateway Integration:
Every thing which is available in your website like automation , B3G1 ,payment gateway , invoice print , order tracking , custom checkout page , and more 40+ features which is helping you to sell products . and customer interface is try to so easy to all Google related also. CRM, social login
My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the
Title: Django Performance Optimization Engineer Job Description: We are seeking a skilled Django Performance Optimization Engineer to join our team and enhance the speed and efficiency of system. As our system experiences slowdowns due to excessive dependencies and unoptimized code, we are looking for an expert who can analyze, diagnose, and implement solutions to improve overall performance. Responsibilities: i. Conduct thorough analysis of our Django-based system to identify performance bottlenecks and areas for improvement. with our development team to refactor and optimize existing codebase for better efficiency. and recommend improvements to database queries, caching strategies, and overall system architecture to enhance performance. Django
I'm in need of a professional SEO advisor to rescue my forex broker review website that is currently underperforming. The main goals are to: - Increase organic traffic - Improve search engine rankings - Enhance user engagement The website's decline is due to: - Poor keyword optimization - Slow website loading speed - Low-quality backlinks The focus will be to optimize the website to rank well for the following phrases: - Forex broker reviews - Forex trading platform - Best forex brokers Ideal candidates should have a strong background in SEO, particularly in the financial industry, and experience in website performance optimization. Understanding of forex trading and knowledge of relevant keywords is a perk. Proven success in increasing or...
I have a roofing business in Czech Republic, I want someone to create Google Ads Campaigns. I don't have a very large daily ad spend (10$). I just want to get the best rapport quality-price from my buget.
I am looking for an experienced WordPress designer who can contribute to boosting the performance of my website. Additionally, a candidate who excels at enhancing SEO via backlink analysis is desired. Key Responsibilities: - Optimize the performance of my website to increase its speed and efficiency, enhancing user experience. - Create and implement an effective backlink analysis strategy to improve and maintain our SEO rankings. Skills: - Familiarity with WordPress platform - Track record in performance optimization - Strong understanding of SEO, particularly backlink analysis Experience: - Prior experience managing and optimizing WordPress sites - Proven background in SEO enhancement through backlink analysis
I am seeking talented freelancers to develop an Arduino UNO bluetooth car for my personal hobby project. It requires expertise in Arduino programming and physical assembly of the car kit. The specific features I want are: - Directional movement: The car should smoothly move forward, backward, left, and right via remote bluetooth controls. - Speed control: The speed of the car should be adjustable. The ideal size I'm seeking for the car is medium, neither too compact nor too large. Experience with remote control vehicles and Arduino, as well as understanding of bluetooth technology, will be a plus for this project. I am looking forward to your innovative design submissions and technical solutions.
I'm looking for a skilled Java developer to help with a dependency issue in my project. The dependency currently has a compile time scope and we need to update it to a test scope. This update is moderately important, but it is essential for the project's integrity. The main goal behind this update is to resolve conflicts with other dependencies. One of the modules of the project is using a class textContext from the package 'context' from the same dependency, madhattee.fixture. This class is primarily used for unit testing, and it's crucial that the update does not disrupt this functionality. Ideal skills for this job: - Strong Java development experience - Proficiency in managing and updating dependencies - Familiarity with testing frameworks, especially...
I'm in search of a top-notch developer with a minimum of 10 years of experience to modify my existing event booking site. The project entails: * Revamping the user inter...website's color scheme and improve the navigation menu for more tailored user experience. * Developing new functionalities: I need your proficiency in integrating a booking calendar and a payment gateway to make the booking process smoother. * Boosting website performance: With my vision for an optimized website, I expect an improvement in website load speed and overall performance. Your creativity will also play a key role in the project, as I appreciate a team member who can suggest ideas to better enhance the website. Experience in UX/UI design, website performance...
I've a research paper I've done on this problem: "Start with $1 million portfolio. Invest 70% in 10 actively managed mutual funds that have outperformed over 10 years. Allocate 30% to 20 individual stocks screened for earnings growth, valuations, profitability and momentum. Back test over 15 years versus S&p;P 500. Evaluate returns, risk and rebalancing strategies." unfortunately the feedback i got was "You claim that you did portfolio optimization but there is no information how you did it. There is no covariance matrix no correlation coefficients obtained from data " I'm looking for someone to help me complete this project before may 5th , 11:59PM pacific time. I am seeking a financial expert to optimize my portfolio with an emphas...
...typed into a digital format. The content is highly legible and clear to read. I'm looking for a skilled typist to accurately transcribe this content into a digital document. Key requirements include: - Ability to understand mathematical equations, draw graphs. Ability to work with PDF files: The notes are in PDF format, and it would be ideal if you have experience with this format. - Typing Speed: As this is a large project, I'm looking for a freelancer who can work efficiently and deliver the project in a reasonable timeframe. - Accuracy: The content is important, so I need someone who can maintain high accuracy levels in transcribing the text from the notes. The successful candidate will be someone with a high level of attention to detail, and a proven track recor...
I'm experiencing an issue with a specific function in my PHP code. The function is not working as expected. Details: - The function is a relatively minor feature in my application; it's not critical to the overall functionality, but it's still important that it works correctly. - I'm experiencing this issue in my local development environmen...overall functionality, but it's still important that it works correctly. - I'm experiencing this issue in my local development environment, so it's not affecting my live application. Ideal Skills: - Strong experience with PHP, and in-depth knowledge of functions and their behavior. - Proficiency in troubleshooting and identifying the root cause of issues. - Ability to efficiently fix the problem and test t...
