How does Trie and B+ tree compare for indexing lexicographically sorted strings [on the order some billions]?
It should support range queries as well.
From perf. as well as implementation complexity point of view.
If you're trying to build an application that needs to have the highest possible sustained network bandwidth, for multiple and repetitive file transfers (not for streaming media), will having 2 or more NICs be beneficial?
I am able to backup mysql database via command line by executing the below :
C:\MySQL\MySQL Server
5.0\bin\mysqldump\" -uroot -ppassword sample \"D:/admindb/AAR12.sql\"
But there is no DROP and CREATE database queries in my .mysql file
What should i add in the syntax to get the create info to my generated .sql file ?
Hi, another iPhone newbie question...
I have the following:
NSPersistentStoreCoordinator
NSManagedObjectContext
NSManagedObjectModel
Is it possible to run queries directly on the store (since its a sqlite DB)? I'm trying to delete all the records from a tableview, and figured a "DELETE FROM table" would be nice and quick as opposed to looping through the records and removing them manually (which i'm also struggling with).
Thanks for your time,
James
Hello, I am developing a new Java Desktop app. Something like a media player. I want to load most of the resources in the background when the computer starts up. But the users can turn this option off form within the app or using some other utility. So, what I want to do is if a ban instance of the app is already running and the user starts the app again then I can communicate with the already running instance so that it can launch a new window?
Hi,
I know i can extract a file's icon using
using (System.Drawing.Icon sysicon = System.Drawing.Icon.ExtractAssociatedIcon(filePath))
{
icon = System.Windows.Interop.Imaging.CreateBitmapSourceFromHIcon(
sysicon.Handle,
System.Windows.Int32Rect.Empty,
System.Windows.Media.Imaging.BitmapSizeOptions.FromEmptyOptions());
}
But how can I extract the icon without a given file?
I have a query regarding my report, the report format is as under
**Date** **Received** **Closed** **Pending**
12/01/10 1000 900 100
12/02/10 2000 1000 1000
12/03/10 1500 1300 200
The above report shows the Help Desk tickets Received, Closed, Pending Count as date wise.
How can I create a dynamic SQL query to show above result?
Received Tickets is calculated on SubmitedDate
Closed Tickets is calculated on ClosedDate with status "Closed"
same for Pending Tickets whose status is "Pending".
Please provide me the idea or some sample SQL queries.
Most often the cleanup rules (Preferences Java Code Style Clean Up) in Eclipse work perfectly and create nice-looking code.
But sometimes, especially with comments and concatenated string snippets (like inline SQL queries), the cleanup just messes things up, and destroys my formatting.
Is there a way to say to Eclipse "Don't touch this block of text! I have formatted it just the way I like, and you would make it just less readable"?
I have table "PICKITEM"
PARTID QTY
A 1
A 3
B 11
C 8
D 5
D 3
I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is
PARTID QTY
A 4
B 11
C 8
D 8
Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!
I have various VB6 projects I'm maintaining with some of the queries being passed to the server having "ELSE:" with the colon used in case statements.
I'm wondering can someone tell me what the **ll the colon is used for? It causes errors in SQL2005 and greater, but SQL2000 works with no complaints.
I'd like to just remove it from the code & re-compile, but I'm afraid it'll break 10 other things in the application..
Thanks in advance...
Hi there,
I would like to be advised on what would be better (in regards to performance)
A) 1 DATABASE with 4 tables
or
B) 2 DATABASES (same server), each with 2 tables.
The tables size and usage are more or less similar, so the 2 tables on Database 1 would be similar usage/size to the 2 tables on database 2
The tables could have +500,000 records and the 2 tables on each database are not related (no join queries etc between them)
Thanks in advance for your comments
Hi,
I am looking for a free/cheap SQLite editor that can handle BLOB type for Mac OS X. Basically, I just need to create a database that contains images, then load it to an iPhone app bundle. No need for fancy queries. Could someone recommend the best editor available out there for this purpose?
Thanks a lot
Hi! I'm using MySQL with PHP. This is like my table: (I'm using 3 values, but there are more)
id | 1 | 2 | 3
1 | 3 |12 |-29
2 | 5 |8 |8
3 | 99|7 |NULL
I need to get the greatest value in a certain row. If should get: (id - output) (1 - 2), (2-2), (3-1). Is there any queries for this? I've been trying, but I can't get it to work right.
Hi,
First of all, i hope i post in the right section. I came across this best media convertor open source software. It works fine and the most convenience thing about this software is the context menu however the context menu isn't working on Windows 7 64bit.
Since i have no knowledge with c++, Can you one here generously help me compile it into 64bit version.
Below are the software I am talking about
Homepage:
htp://www.oxelon.com/media_converter.html
Source:
http://sourceforge.net/projects/oxelonmediaconv/files/oxelonmediaconv/oxelon_source_code/omc_src.zip/download
Not quite sure how to ask or define this, but can't figure it out.
I have three tables like this:
persons person_id, first_name, last_name
hobbies hobby_id, name
persons_hobbies person_id, hobby_id
I need to make two lists. Persons that have both hobby A and B, and persons that have hobby A but not B. How can I write these two queries? Can't figure out how to do this with joining and all...
What are the most efficient SQL queries that would take an existing MySQL table and re-sort it by one of the columns? Not a selection, but the whole table should be sorted by one column. Somehow using a temporary table, I guess, but what's the best way?
This is my first time building a responsive site, and as I tailor the CSS for the iPhone I'm running into a problem. The styles all apply correctly, the text changes size and the wrapper changes widths. The problem is the iPhone browser still opens up at a huge width, see the screenshot:
I'm using
@media all and (max-device-width: 480px) {}
to set the specific iPhone css. body {width:;} doesn't work.
Thanks for the help :)
I'm trying to simplify my views and get rid of some of the nested layouts, and I noticed while looking at the hierarchyviewer that embedded Activities in a TabHost have a PhoneWindow$DecorView. Is there a way I can get rid of this?
An example is here:
http://www.vimtips.org/media/hv.png
Suppose a query "select * from employee" returns 80 rows. I need to display middle rows that is from 20th row to 50th row.
I know, like to display first 20 rows we have option like "select top 20 * from employee" but if we need middle rows how to get it in MS SQL specifically.
I m new to this SQL queries...Can anybody answer to this question.
Hello,
i'm using CodeIgniter for developing a community board. As I'm using nested sets to get a nested forum hierarchy, I have to run a lot of queries such as:
SELECT `id` FROM `forums` WHERE 1 BETWEEN `lft` AND `rgt`
My problem: CodeIgniter is replacing the "1" by "`1`" because the "1" is recognized as a column name. Of course, the query does not work any more.
Is there a way to get it working?
thx in advance
I'm trying to avoid using an in memory database for testing (though I might have to do this if the following is impossible). I'm using NHibernate 3.0 with LINQ. I'd like to be able to mock session.Query<T>() to return some dummy values but I can't since it's an extension method and these are pretty much impossible to test.
Does anyone have any suggestions (other than using an in memory database) for testing session queries with LINQ?
Currently I am using mysql to log all traffic from all users coming into a website that I manage. The database has grown to almost 11m rows in a month, and queries are getting quite slow. Is there a more efficient way to log user information? All we are storing is their request, useragent, and their ip, and associating it with a certain website.
I use queries like
"UPDATE MAILSCH.MESSAGE "
+ "SET IDFOLDER=?, SUBJECT=?, CONTENT=?, CREATIONTIME=?, AD_FROM=?, AD_TO=?, STATUS=? "
+ "WHERE IDMESSAGE=?";
May I miss out IDFOLDER without changing query?
I'm running a search with a type field. I'd like to show results of a certain type ONLY if two other field have values for them. So in my filter query I thought it would be(type:sometype AND field1:* AND field2:*) but wildcard queries can't start with the *.
This is my queries
select ClientName,ClientMobNo from Clients
select DriverName,DriverMobNo from Drivers
It gives me two result tables... But i want to combine both the result tables into a single table... I tried union and union all it doesn't give me what i want....
Note: There is no relationship between the two tables...... There may be 200 clients and 100 drivers...