Do .Net int and long types have different size on 32 bit and 64 bit platform ?
Does int (=Int32 on 32 bit machine) on 64 bit machine will be still Int32 not Int64 ?
Can you quote any official .Net documentation ?
Hi all,
I am using a following query in MySQL for fetching data from a table. Its taking too long because the conditional check within the aggregate function.Please help how to make it faster
SELECT testcharfield
, SUM(IF (Type = 'pi',quantity, 0)) AS OB
, SUM(IF (Type = 'pe',quantity, 0)) AS CB
FROM Table1
WHERE sequenceID = 6107
GROUP BY testcharfield
hi guys,
Just Wondering how [session] timeouts are(or can be) implemented when using Comet?
I'm using Long polling Comet solution and want to implement a kind of Timeout feature.
Example :
If the user is on a comet enabled page and doesn't respond to server events/notification for a period of time say 10 mins then invalidate his session and remove his request from server and redirect the user to a timeout page?
Will this require Javascript XHR requests to check for a timeout explictly?
Using ASP.NET 3.5 / C#
Thanks
Suppose some user logged in to VSS for long time but VSS admin need to log off those user who is not using VSS for certain periode of time(such as 15 minutes).How to do it?
I have a field as follows in MySQL:
Type: Text
Length: 0
Decimals: 0
And when I try to insert data around the size of 4 pages of MS Word, Coldfusion errors with: Data Too Long from the DB.
I thought TEXT data type was able to expand and handle this size of data? What am I missing and what can I do?
Hi, I wonder if there is a canonical way to convert data from long to wide format in SQLite (is that operation usually in the domain of relational databases?). I tried to follow this example for MySQL but I guess SQLite does not have the same IF construct... Thanks!
hello.
What is the actual precision of long double on Intel 64-bit platforms?
is it 80 bits padded to 128 or actual 128 bit?
if former, besides going gmp, is there another option to achieve true 128 precision?
How can we convert the following 64 bit binary into the long equivalent;
01111101 10100011 01001111 11111111 11111111 11111111 11111111 11000000
equals 7D A3 4F FF FF FF FF C0 HEX
equals 9053167636875050944 << this is the value we want in a C# variable
I have compiled and jarred the various projects in my Java application, generating serialVersionUIDs automatically through Eclipse for all my classes derived from Serializable.
I read the answers to this question, and verified that serialVersionUids are all private static final long.
Nevertheless, I get an error like this when I try to run:
java.io.InvalidClassException: com.acme.product.Widget; local class
incompatible: stream classdesc serialVersionUID = 5226096973188250357, local
class serialVersionUID = -5432967318654384362
What am I missing?
In the C language: How do I convert unsigned long value to a string (char *) and keep my source code portable or just recompile it to work on other platform (without rewrite code)
I have a simple query that does select * from t limit 1; on a remote mysql server.
I use squirrel(mysql client) to run it, it shows:
Query 1 of 1 elapsed time (seconds) - Total: 22.047, SQL query: 1.047, Building output: 21
why does building output take such a long time? what does this process do? when running from mysql command line, the whole process takes 0.3 secs (also remotely)
How do I delay a PHP script that writes to a text file and then reads from the same file long enough to make sure changes have been written before I attempt the read?
I having trouble scraping a certain long dash that is encoded as ; on the Time magazine site. It looks like this: —. It works fine when this dash is encoded as mdash, but when the problem dash is scraped, it is returned as unknown characters. I am using Nokogiri and am wondering if I have to use some sort of special encoding? The page says it is encoded with UTF-8.
Hi all,
My source gave me the following lat and long codes from Amsterdam. But I can't get them working with Google Maps. Is there some logic behind it, or some kind of algorithm to convert them?
5,237,300,539,279,090 | 489,290,714,263,916
Should be something like this:
52.378268, 4.888859
How can one tell where the dots should be?
Thanks!
Hi at all,
I want to know if this web app are using long polling or anything else "javascript trick":
http://typewith.me/2wicOjuefI
Is there a way to know that ?
Thanks ;)
How do I automatically interrupting long queries in the mysql, if it possible?
I'm understand, that I need optimize queries instead of. But now I have access on database server only.
I have a php mysql query like this
$query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10";
As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing.
But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit.
Let's discuss how we can improve on such long query.
I have a php mysql query like this
$query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10";
As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing.
But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit.
Let's discuss how we can improve on such long query.
My application is suppose to constantly update the page without any user interaction. The criteria is that the page just has to be there, as an extra window on the monitor so the user can see the information get updated real time.
I'm using the Ajax in jQuery with Rails, and my question is - how long will the .erb page keep Ajax open? Will there be a point where I have to refresh the page or re-initialize? Or will that won't be a problem at all?
I am pulling a long timestamp from a database, but want to present it as a Date using Tags only, no embedded java in the JSP. I've created my own tag to do this because I was unable to get the parseDate and formatDate tags to work, but that's not to say they don't work.
Any advice?
Thanks.
i have a php page which auto refreshes itself after 10 seconds. Some time the page takes too long to load as its fetching data from external urls . How can i stop execution of the script after 10 seconds and then reload the page.
I want to generate a PDF of user-submitted text using LaTeX. To handle crazy user input, I first thought about using the verbatim package, but of course it doesn't break up too long lines. Is there some package that works similar to verbatim (i.e., accept any input) but formats the text nicely?
Is it possible to constraint a method so that it receives only int, double, long or other numerical types that has the usual numerical operations ( such as +,-,*,/) defined?