1) Not sure what you mean by optimisation. I am making sure that where possible, indexes are being used for joins (the data was designed to be queried roughly how I query it)
2) The query joins on 3 tables, but I wouldn't consider it overly complex
3) No I did not have a look at the explain plan, because I didn't really think it was overly relevant to the question - I hoped someone might discuss whether on the whole they think it more...
Brosert
Joined: Jul 23 '08
Location:
-
Where and how is waveOutDevices (passed to your switch statement) set?
Currently, it appears that within playAllAvailabl eDevices
you switch based on a variable that is never set.
Further, there is only 1 pass through the function, so only 1 device will ever play.Leave a comment:
-
How efficient are queries that use DISTINCT (vs filtering data yourself)
I have a query on a database that returns a large number of rows from a database (somewhere near a million) to an application that then does some processing with them. Some of these returns may be duplicates, and I considered using DISTINCT to make sure these duplicates do not occur, however I suspect I would be better off filtering the duplicates within the application, rather than within the database.
My justification would be... -
Webservices and DLL's (in third party software)
I realise that many people have asked very similar questions, however none of the solutions outlined seem to quite fit my problem.
I should point out that I am new to both c# and the very idea of WebServices ....
I have a Webservice that calls a managed (?) DLL from a third party. This DLL in turn requires another DLL (not managed), which appears to me to be C or C++ based.
When I try to run the WebService, I... -
(
Raghu,
I would imagine because he is printing Hex numbers...
It's common to see Hex numbers prefixed with "0x" to identify that they are in base 16 rather than base 10...
0x32 (50) is easily distinguished from 32 (32)....
)Leave a comment:
-
This sounds like Homework....Leave a comment:
-
is "Form" a function that you have created yourself, or does it come from an external library.Leave a comment:
-
Eclipse needs to be able to see the Java 5.0 files (which it may not be able to now that they have been moved to d:
Make sure Eclipse is pointing to the correct version of Java -> it sounds like you might be picking up an older version of java (again, possibly because you moved the newer one)
You could pass the integer as a (new) Array {val}, or you could use java's print rather than printf - but this hides...Leave a comment:
-
Which version of Eclipse are you running?
What is version is Compiler compliance set to?Leave a comment:
-
Brosert replied to I need help In php ; When i Select a checkbox;is sending to all Emails and not to Onein PHPLeave a comment:
-
Believe it or not:
http://www.freehost.ne t.au/
will give you quite a bit of free webspace (with only a little, almost unnoticeable link to themselves down the bottom).
As far as I know, they will give very little in terms of 'Instant pages' (rather they assume you can make your own pages - and are comfortable uploading them one way or another).
Obviously they have conditions about what you can and can't do with...Leave a comment:
-
Thanks Jos,
Actually the problem was that I was using cells without the concept of walls - that is, this cell is either filled in or it isn't. In this way, each 'cell' was a filled square - and was either there or not (so the whole thing could be stored in a boolean array.
Everything I found on the net seemed to suggest the same sort of method you specified, but I really didn't want to change the way I was drawing the maze...Leave a comment:
-
The PHP needs to be installed on the server that is hosting the web page - which if you're using a professional hosting service, it usually is!! - if you're using you're own server from home/work you would need to install it!
(Incedently, silly me didn't read that you weren't so interested in php solutions)Leave a comment:
-
Why are there 4 seperate Times in the field??
I think you will have to manipulate the string yourself....
firtunately, the field should always be the same size. You can use the php substr method which takes string, offset and lengh as arguments....eg , the first hour would be
the second would beCode:$hr1=substr($Date,0,2);
...Code:$h2=substr($Date8,2);
Leave a comment:
-
Do you get the wrong output for smaller strings, or none at all?Leave a comment:
-
Not real sure....
try changing
count = sizeof(string1) to = strlen(string1) (as you had in your first program....
Meanwhile I'll have a deeper look/thinkLeave a comment:
-
because only half of the characters go in each string....
so string2 and string3 will be half the size of string1.
In c (and I think most languages) if we divide a number in a place where we can only use an integer, it will autometically round the number down....
so 0/2 = 0 (obviously)
but 1/2 = 0 (because we can only use the integer part of the answer).
this means, that if we always take the current...Leave a comment:
-
Part of the problem is that it always takes the THIRD character....
If your string is shorter than 3 characters, it takes a (probably) NULL character, which terminates the string, and would give you a single character output....
where you get string try making the following modification :
...Code:int charAt =2; count=strlen(string); //If we have a short input, take the last letter instead
Leave a comment:
-
in that case, use a for loop....imnstea d of the while loop
eg
Code:int count = sizeof(string1); for(int x=0; x<count; x++) { /Check whether x is a multiple of 2 if(x%2 == 0) { string2[x/2] = string1[x]; } else { string3[x/2] = string1[x]; }Leave a comment:
-
Truth be known, that wasn't quite what I meant....
But great to hear it's working!!!Leave a comment:
No activity results to display
Leave a comment: