Postgres pgsql query optimization(repost)–By jennifermiller on Oct 9–Max Bid: $50

October 9th, 2008

We have 8 extremely slow sql queries. We are using Hyperic HQ Enterprise server, and it uses Postgre as its backend database. The 8 report queries we programmed sometimes timeout because they run so (more…)

Keywords:Database,SQL Server,MySQL,Oracle,Other (Database),Other







Related Projects

Postgres pgsql query optimization–By jennifermiller on Oct 8–Max Bid: $50


We have 8 extremely slow sql queries. We are using Hyperic HQ Enterprise server, and it uses Postgre as its backend database. The 8 report queries we programmed sometimes timeout because they run so (more...) Keywords:Database,SQL Server,MySQL,Oracle,Other (Database),Software Related (Includes Websites),OtherPlace Your Bid Post similar project 

postgres to mysql conversion


Hi,I have an old product that was created for me for a postgres database that I need converted into mysql format. It's mainly the create table etc conversion that is needed to begin with but we might even need a conversion of the php files as well (templates etc). But bid for the database design conversion to begin with. (Budget: $20-100, Keywords: PHP)

Freeside install and configure Phase1and 2


50% of bid paid to Install freeside open source ISP Billing Script with Mason and all the needed perl modules for RT ticketing via ssh access.Configure apache,intergrate with exsisting freeradius (mysql, but can change to postgres)server and install online signup page on seperate www server.Install Iptable forward rule to use freeside private server and bring freeside server to a fully working, usable state to complete Phase 1Completed Phase 1 and verified usable state payment = 35% of bid price paid.Phase 2 = install payment moduleCompleted Phase 2 and verified usable state = 15% of bid price paidSystem pref:Will accept a

Looking for .net and Postgres SQL expert


I am looking for a .net and PostgeSQL expert who can help me bring to life my software I have installed on my machine! Additional information submitted: (Budget: $30-100, Keywords: .NET) Place Your Bid

JSF Application Development With Database Backend


Need to create a web-application using JSF, from scratch. You will be provided with html-designed pages that you can use to create the application. So there will not be much UI/web-page designing involved. This is more of an application development project. The application will have atleast 30 or more screens (probably more, as we enhance it). Development work will also involve creating a Postgres database, and connecting to it from the JSF application. We will provide you with database tables in MS-Access. You can use that to easily create the needed tables in Postgres.Experience with Sun Creator 2 (for

User Administration


This project requires, free radius, php, mysql, postgres, mssql and encrypting the php scripts.

MySQL Database / Query optimization


We've got a site that is very query intensive and dynamic. Our mySQL load is going nuts and causing site-slowness. We'd like an expert to take a look at our configuration, the stats etc, (like that page on phpmyadmin that helps show your trouble spots), and possibly even look into our major queries to see if we can optimize anything. (Budget: $30-100, Keywords: Data Processing, PHP)

!!! Now Hiring !!!


We are now hiring full time for our IT needs. The employees will need to be self motivated, working from their own location and finishing projects that we give them. You will be employeed as a regular employee and paid a monthly salary. Every evening you will have to do a log stating what exactly you did and how many hours you spent on it. Please leave PM explaing what kinda of work you have done in the past.Positions available:Web Developer (3) - PHP, asp, mySql, access etc.DBA

Jasper Reports automatic running–By jennifermiller on Oct 8–Max Bid: $50


We are running Jasper Reports (it is integrated into another product named Hyperic HQ Server). We hae created 30 Jasper reports and we run them via the web interface. The task is to somehow automa (more...) Keywords:Database,Linux,SQL Server,MySQL,Oracle,Other (Database),Emergency!,Emergency production fix/patch,Other (Emergency),OtherPlace Your Bid Post similar project 

PHP + Oracle Database


Looking for an expert with linux servers, oracle database software and php scripts.We need help setting up a linux server for use with Oracle 10g Enterprise edition, so that php scripts can connect to a remote server. We also need a you to code a php function so we use the script for current php scripts to be able to connect to the oracle remote database server.Please ONLY offer if you can help us without any problems. (Budget: $30-100,

Install OpenReports–By jennifermiller on Oct 10–Max Bid: $100


We are runnning software (HYperic HQ Enterprise) that uses Jasper Reports for its reporting engine. e have created about 20 jasper reports. Now, we want the ability to schedule these reports to be (more...) Keywords:Database,Java,SQL Server,MySQL,Oracle,Other (Database),Emergency!,Emergency production fix/patch,Other (Emergency),OtherPlace Your Bid Post similar project 

We need Programmers for teaching PHP , MySQL ,Visual C++ , Delphi ,.NET , C# ,JAVA , JSP ,Power Builder ,Cold Fusion, Perl,Python , Search Engine Optimization ,Linux , Unix ,XML/XSL ,Database - Oracle, SQL Server,Access, C++ / C , Assembly / Machine langu


We need Programmers for teaching PHP , MySQL ,Visual C++ , Delphi ,.NET , C# ,JAVA , JSP ,Power Builder ,Cold Fusion, Perl,Python , Search Engine Optimization ,Linux , Unix ,XML/XSL ,Database - Oracle, SQL Server,Access, C++ / C , Assembly / Machine language, Javascript ,ASP, ASP.NET, Visual Basic,Visual Basic .Net , Web Page Design ,Flash ,3d Modeling ,3d Animation ,Adobe AfterEffects to students in Jaipur (Rajasthan , India).We can pay from Rs. 1000 (22 $) to Rs. 10000 ($ 229) per month depending upon caliber of the teacher and no. of languages he/she knows. Please quote all

.Net 2.0 DAL with Oracle, MySQL & SQL Server 2000/2005


I need a .Net 2.0 framework implementation with the following features.- DAL supporting Oracle, MySQL and SQL Server- Implementation of .Net 2.0 membership/profile provider for the above listed databases (Budget: $100-300, Keywords: .NET) Place Your Bid

OpenReports / Jasper Reports–By jennifermiller on Oct 8–Max Bid: $50


We are runnning software (HYperic HQ Enterprise) that uses Jasper Reports for its reporting engine. e have created about 20 jasper reports. Now, we want the ability to schedule these reports to be (more...) Keywords:Database,Java,SQL Server,MySQL,Oracle,Other (Database),Emergency!,Emergency production fix/patch,Other (Emergency),OtherPlace Your Bid Post similar project 

Programmers for teaching PHP , MySQL ,Visual C++ , Delphi ,.NET , C# ,JAVA , JSP ,Power Builder ,Cold Fusion, Perl,Python , Search Engine Optimization ,Linux , Unix ,XML/XSL ,Database - Oracle, SQL Server,Access, C++ / C , Assembly / Machine language, Jav


We need Programmers for teaching PHP , MySQL ,Visual C++ , Delphi ,.NET , C# ,JAVA , JSP ,Power Builder ,Cold Fusion, Perl,Python , Search Engine Optimization ,Linux , Unix ,XML/XSL ,Database - Oracle, SQL Server,Access, C++ / C , Assembly / Machine language, Javascript ,ASP, ASP.NET, Visual Basic,Visual Basic .Net , Web Page Design ,Flash ,3d Modeling ,3d Animation ,Adobe AfterEffects to students in Jaipur (Rajasthan , India).We can pay from Rs. 1000 ($ 23) to Rs. 10000 ($ 229) per month depending upon caliber of the teacher and no. of languages he/she knows. Please quote all

Php Won’t Connect To Oracle Se


Hi, I have a Linux VPS with Oracle Gateway installed on it. But my PHP scripts aren't able to connct to remote Oracle 9i Server (which hosts on a different machine) My Oracle Server is all fine, and the same PHP script hosted on a windows server of mine is able to connect to this Oracle server well. This is my first time trying to connect to a remote Oracle Server from a script hosted on Linux (i have done it well on Windows servers before), so probably my configuration file or source cod...Place Your Bid Post

Drupal 4.7 Mysql Query Optimization


Hello,We are looking for someone very familiar with the Drupal 4.7 framework and can help optimize the mysql queries and possibly implement a better caching mechanism fspath / boost. Please PM with past experience and samples / reference.Thank you!PS. Based on the devel module output some pages are reaching close to 700+ query request. Its a problem we need to solve soon as its repeatedly crashing our servers. (Budget: $300-1500, Keywords: PHP)

C#/.Net flat file DB and msSQL or Postgres convert


Currently I have a custom built flat file fixed-field database. It simple saves usernames and passwords, and a few other pieces of info.Currently a c# application does random access read and writes on the file database, and this application has been running for many monthsproblem free. It needs to be enhanced. There are 2 real main things that need to be done. 1) A in ram data structure to allow chaching, so thatreads are done WITHOUT disk access, and archiving, and 2) the data has to sync with either a postgres DB or a MSsql DB. Perferably a Postgres DB.

Dynamic MySQL Header Query - RePost!


I recenlty posted this project a few days ago, however the selected provider could not handle the task. I am looking for an extremely SHARP MySQL developer. A person that knows more than how to do your average "SELECT" statement. I am looking for a query that will provide dynamic result headers with corresponding information results. I have attached a txt file to this project, to help better explain what it is I am looking for.

MySQL to Oracle Support for PHP Application


Current PHP application only supports MySQL DB. Client needs it to support Oracle DB. The conversion will require 2 parts:1) Replicate DB structure from MySQL to Oracle.2) Update PHP codes to use Oracle DB functions instead of MySQL functions (approx 40 PHP files)(eg. mysql_fetch_assoc to its Oracle equivalent).Freelancer will be provided wth SQL code for MySQL DB and PHP application files in clear text.Deliverables:1) CREATE file for Oracle DB.2) Modified PHP codes. (Budget: $30-100, Keywords: Data Processing, PHP)