We are currently thinking of building a cache-system to hold data pulled out of an SQL database and make it available to a couple of other applications (website, webservice, etc). We imagine the cache to be running as a windows service and basically consist of a smart dictionary which holds the cache entries. My question is, is there a l...
After a few hours of searching, I'm not getting anything that works with Sqlite. It's driving me nuts. I have an sqlite table that contains prices for various products. It's a snapshot table, so it contains the prices on 5 minute intervals. I would like to write a query that would return the difference in price from one row to the next ...
For a load test of my application (under Linux), I'm looking for a tool that outputs data on stdout at a specific rate (like 100 bytes/s), so that I can pipe the output to netcat which sends it to my application. Some option for dd would be ideal, but I didn't find anything so far. It doesn't really matter what kind of data is printed (N...
I am writing a stored procedure where I have an input parameter called my_size that is an int, I want to be able to use in a limit clause in a select statement. Apparently this is not supported, is there a way to work around this? # I want something like: SELECT * FROM some_table LIMIT my_size; # Instead of hardcoding a permanent limit...
I am trying to script SCCM 2007so I don't have to manually go through 400 servers and set the rate limit by hand. I want all of the servers to use 75% of their bandwith 24 hours a day. I am guessing powershell and wmi is going to be the best way to go about doing this, but any suggestions would be welcome. ...
Hi, My code opens more than 256 file handles, So When I run it on solaris machines I am ending up in "Exceeding file handlers limit" error. I have two questions regarding this 1) Is this limit is only for 32 bit softwares or 64 bit softwares also suffer from it. I googled about it and came to know that 64 bit softwares do not have thi...
We run a large online community in the Netherlands. Because of that we send a lot of mail to the hotmail email addresses of our members. Recently we have noticed that not all mail is reaching our members, because we have hit a certain limit or so it seems. Google doesn't give a solution (yet) but we see a lot of others having the same p...
I've queued up over 10,000 files to be uploaded to a UNIX based FTP server using a freeware (Windows based) FTP client which as far as i can see has finished without error. Now, when i view the remote directory (using the Windows software) the output is truncated to 10,000 filenames. This ever occurs when i use the Windows command line ...
Hi! I have the following problem: some processes, generated dynamically, have a tendency to eat 100% of CPU. I would like to limit all the process matching some criterion (e.g. process name) to a certain amount of CPU percentage. The specific problem I'm trying to solve is harnessing folding@home worker processes. The best solution I c...
Hi, If I had a million images, would it be better to store them in some folder/sub-folder hierarchy or just dump them all straight into a bucket (without any folders)? Would dumping all the images into a hierarchy-less bucket slow down LIST operations? Is there a significant overhead in creating folders and sub folders on the fly and ...
Hello. I'm using the TServerSocket component in my Delphi application. I would like to limit client connections, let's say to one thousand. Unfortunately i don't know how to do that. The component does not provide any properties like 'MaxConnections' or any other like this one. I create new server threads (TServerClientThread) using th...
I am programming a server and it seems like my number of connections is being limited since my bandwidth isn't being saturated even when I've set the number of connections to "unlimited." How can I increase or eliminate a maximum number of connections that my ubuntu linux box can open at a time? Does the OS limit this, or is it the rou...
I would like to set a maximum execution time for sql queries like set_time_limit() in php. How can I do ? ...
I need to check a double value for infinity in a C++ app on Linux. On most platforms this works by comparing with std::numeric_limits<double>::infinity(). However, on some old platforms (RedHat 9 for example, with gcc 3.2.2) this is not available, and std::numeric_limits<double>::has_infinity is false there. What workaround would you re...
Hi, I have a bit of PHP code which I need to return an even number of results from a MySQL database. I'm using the mysqli extension to execute my query. My code is approximately this at the moment: //assume we already have a database connection $query = "SELECT id FROM movies WHERE publish = 1 AN...
I have found a way to select random rows from a table in this post. A suggestion is to use the following query: SELECT * FROM employee ORDER BY RAND() LIMIT 1 But when I run this query in MS SQL 2005, I get the following error message Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'LIMIT'. Can anyone tell me where am I wr...
When I add LIMIT 1 to a MySQL query, does it stop the search after it finds 1 result (thus making it faster) or does it still fetch all of the results and truncate at the end? ...
I am using JTextArea in JScrollPane I want to limit the maximum number of lines possible and the maximum chars in each line. I need that the string will be exactly like on the screen, each line will end with '\n' (if there another line after it) and the user will be able to insert only X lines and Y chars in each line. I tried to limit ...
Hi, I wrote a query select u.user, g.group, u2g.something from users, groups, u2g where users.u = u2g.u and groups.g = u2g.g that returns data like this: user, group, something ---------------------- 1 , 3, a 1 , 5, b 2 , 3, c 3 , 3, d 4 , 5, e now I would like to limit this query in such a way th...
for example will select * from table limit 0,5 return at most 5 rows or must it find exactly 5 and if the row_count doesnt equal 5, it returns an empty result set? what if the query was select * from table limit 5? ...