I have a problema with a select distinct, I have the next sql:
select distinct a,b,c,d from (select a,b,c,d,e,f...from table where ...)
The subselect have 25000 rows, it last about 10 seconds, but the select distinct over the subselect takes a long time..., I have waited for 20 minutes, and finally canceled the sql.
When I make this alternative path:
create table2 as (select a,b,c,d,e,f...from table where ...)
select distinct a,b,c,d from table2
The distinct finish in 5 seconds.
I don't understand the differences.... I can't do the alternative path, I need the first sql to work.
I don''t know where is the problem
Any advice will be greatly appreciatted
ClientScript.RegisterClientScriptBlock Issue
This is what I haveview plaincopy to clipboardprint?Protected Sub posrback_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles posrback.Click
PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP I've created an html form to allow the user to request a basic telephone directory listing. They can select their 'listtype' by 'all' or by 'state'. If they choose 'state' then they
CE 7.1 and External GIS integration
Hi All,
Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authentication. They hosting service sent me this link: http://email.about.com/od/emailprogramm ...
modifying a property of an object from a different class
I have 2 classes:- Math- Distancein my math class, I have this line:$distance = new Distance($this->query, $this->distances);and this property:public $special = array();in my Distance
square instead of number
HelloI do not know why but this code seems to work fine only in my xampp local insallation but not in the remote server. I just see a black square instead of the number 0000000 when I run this code in
Reditecting pages based on logic
Newbie here, apologies in advance!I am trying to use the header function to forward one of any number of locations (taken from a db) based on the value of a response param:Quote<?php include
output_buffering so rewrite
I'm planning to rewrite some of my scripts so they don't have to use output buffering to accomplish their form validation and html displays......so what rules should i follow when rewriting it so i
Sort a two dimensional array.
Hi. I've set up a two dimensional array that reads as follows:Code: $modifiedData = array( array($arrCollingwoodStart[0], $numCollingwoodForTotal, $numCollingwoodAgainstTotal,
question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.I have roughly 30 files. I want to be able to edit every $_POST and $_GETCode:
