OK, I've got two named lists, one is "expected" and one is "observed". They may be complex in structure, with arbitrary data types. I want to get a new list containing just those elements of the observed list that are different from what's in the expected list. Here's an example: Lexp <- list(a=1, b="two", c=list(3, "four")) Lobs <- lis...
What would be the best approach to optimizing spatial index on geometry data? Specifically: How to choose values for grid hierarchy? How to choose value for Max cells per object rule? These are very much data related so I'm looking for a sensible approach to analyzing the data and then testing out the values. ...
I haven't solved this issue by using the stored procedure, yet we've decided to surpass the SP and just execute the plain ol' SQL Please see the extended table scheme below Edit 2: Updated the index (to not use actieGroep anymore) NB. SQL Server 2005 Enterprise 9.00.4035.00 NB2. Seems related to http://www.sqlservercentral.com/Forums/To...
Is it possible to fine-tune directives to google to such an extent that it will ignore part of a page, yet still index the rest? There are a couple of different issues we've come across which would be helped by this, such as: rss feed/news ticker-type text on a page displaying content from an external source users entering contact pho...
I use Netbeans mainly for PHP. When Setbeans starts, it always indexes all the files of all the projects I have on my list. This can take over half an hour in my case, since I have some very large websites open. It got better in 6.7, 10 minutes at most, but still a waste of time. Still, I'd like to turn off the indexing completely. N...
What programming languages are 1-indexed? So far I've got: Algol Matlab Action! Pascal and Fortran? EDIT: What he meant was languages whose array subscriptions start with 1 instead of 0 like in C. ...
This is related to primary database indexing mechanism (sparse indexing). Binary search can be used on the index file to locate an entry. But, if overflow blocks have been used, binary search will not be possible. Could someone explain how overflow blocks make binary search not possible to use? ...
I have some 1000 key-pair values that I will use in my j2me application, reading it from a resource file. However I will be using only a few of those values at any time, say 10, based on the record number being generated inside the application logic. Loading all the values into memory and then looking up is fairly not an efficient option...
When do you use each MySQL index type? PRIMARY - Primary key columns? UNIQUE - Foreign keys? INDEX - ?? For really large tables, do indexed columns improve performance? ...
Example table: CREATE TABLE Log ( logID int identity logDate datetime logText varchar(42) ) logID is already indexed because it is a primary key, but if you were to query this table you would likely want to use logDate as a constraint. However, both logID and logDate are going to be in the same order because logDate w...
I'm trying to optimize my application by reducing round-trips to my database. As part of that effort, I've been moving some of the tables into memory, storing them as Boost.MultiIndex containers. As a side-effect of this process, I've lost the ability to do wild-card matching on my strings. For example, when the table was stored in My...
How can I compare the performance of an Index on a table using the Query Analyzer? I would like to run the same query through the Estimated Execution Plan twice, once using the index and once without, and have a good comparison of the table scans/index scans that are generated. I have tried CREATE INDEX..., SELECT..., DROP INDEX..., SE...
I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. After restoring from a backup I plan to do the following: ALTER DATABASE <database_name> SET COMPATIBILITY_LEVEL = 90; DBCC CHECKDB(<database_name>) WITH NO_INFOMSGS DBCC UPDATEUSAGE(<database_name>) WITH NO_INFOMSGS exec sp_updatest...
If I create a reverse index in Oracle on a VARCHAR2 column do I also need to reverse the value used in the WHERE clause? CREATE INDEX myindex ON myTable(name) REVERSE; SELECT name FROM myTable WHERE name='Peter'; or SELECT name FROM myTable WHERE name='reteP'; ...
I have heard over and over that you should add indexes to any foreign key you will be doing joins on. I have also heard you should have indexes for fields you will do queries on. Does anyone have a fairly exhaustive list or set of guidelines around when and when not to add indexes? There must be a size of table where it is inefficie...
Consider the following (admittedly long) example. The sample code creates two data sets, data one with "key" variables i,j,k and data two with key variables j,k and a "value" variable x. I'd like to merge these two data sets as efficiently as possible. Both of the data sets are indexed with respect to j and k: the index for the first d...
Have full text index on a table for the purpose of searching and producing a list of results based on relevance, I assign relevance based on the highest "score" from the full text index. The table contains 3 columns, a unique ID, a text field in the type (varchar), and the third is a timestamp of the last edit. The full text index only ...
i've got this union query: (SELECT INSTALLER, INSTALLTIME, RESULT, JOBNUMBER, HONAME, ADDRESS, CITY, STATE, ZIP, NOTES, SMNOTES, '' as priority, PAFS, upsell, TERM, MMRUPGRADE, WARRANTY, EFT FROM ACCOUNTS WHERE INSTALLDATE = '$date' && FUNDINGSTATUS !='DEAD') UNION (SELECT technician, servicetime, result, ID, Customername, address, c...
I was told that there is new a feature in SQL Server 2005 called index filters. What I want to do is add an Index to a column and have the index ignore null values. I can't find good information on this feature (maybe my source is wrong). Can anyone provide additional information on this feature? ...
In order to keep my index up to date, I need to add / modify my search index every 5 minutes. The way I have it set up is with 2 indexes, one in the Full directory and one in the Incremental directory, and to search them I am using a MultiSearcher. I am now writing a process to maintain the index. What I am doing is passing the last ind...