I'm looking for a effective and scalable way of doing the following with the java low level API. I have a query with some sort orders and i would like to fetch the Nth entity. Using the offset argument doesn't seem like a good idea. EDIT Background: I'm trying to write an abstraction layer for DS with a Memcache. The data stored in the ...
I have a view which combines two tables using UNION ALL. Is it possible to create a unique index on the view? ...
Ive made a 'hover with sticky click' jquery script for my web portfolio which works in Chrome, Opera, Firefox, and Safari - but I'm still having some problems with IE. I have 8 thumbnails that fade between 0.3 and 1 opacity on hover. When clicked it uses the index of the thumbnail to show the corresponding full size image. It also is li...
What type for array index in C99 should be used? It have to work on LP32, ILP32, ILP64, LP64, LLP64 and more. It doesn't have to be a C89 type. There are 5 candidates: size_t ptrdiff_t intptr_t / uintptr_t int_fast*_t / uint_fast*_t int_least*_t / uint_least*_t There is simple code to better illustrate problem. What is the best type...
I'm trying to set up a site that forwards everything but the root directory and index into a variable. I have the htaccess file set up like this right now: Options +FollowSymlinks RewriteEngine on RewriteRule -(.*)$ http://blah.com/blah.php?name=$1 [R,NC] just so that the index works and anything that starts with a hyphen(-) is rewri...
What I want to do is something like follows: CREATE INDEX i_table_column ON table(column) IF NOT EXISTS INDEX ON table(column) Is it possible to write the above statement in MySQL? ...
In this file (localization.php): <?php session_start(); header('Cache-control: private'); // IE 6 FIX if(isSet($_GET['lang'])) { $lang = $_GET['lang']; // register the session and set the cookie $_SESSION['lang'] = $lang; setcookie("lang", $lang, time() + (3600 * 24 * 30)); } else if(isSet($_SESSION['lang'])) { $l...
I just started working with the JavaHelp package. I have done some basic modifying of the Table of Contents and such with no problems. My issue arises in that I have created various new help files (added to an existing project within my dev team) and added various sections to existing help files. I now need to make sure that the index.x...
In SQL, when I create a database index, I'm required to give the index a name, as in CREATE INDEX timestamp_index ON hit (timestamp); The only time that this name seems to be necessary is if I want to remove the index with DROP INDEX timestamp_index; Is there any other use of the index name? ...
hi, i've got a sql-query, executed against non-ax-tables ( partially at least ) from x++ via odbc. the sql-query-execution-plan suggests to add an index to the referring ax-table, eg: CREATE NONCLUSTERED INDEX [] ON [ ([field1]) INCLUDE ([several fields]) i remember it wasn't a good idea to create any of those indices via management-s...
hello, i want to set a main page or an index page for my app. i tried adding MAIN_PAGE in settings.py and then creating a main_page view returning a main_page object, but it doesn't work Also, i tries to add in the urls.py a declaration like (r'^$', index), where indexshould be the name of the index.html file on the root (but it obvio...
I want to be able to have an actual list of objects returned when I query, instead of a ResultSet with Hit objects. Example: indexer.search(word).prefetch() this would return a ResultSet object with matching hits, but I would like to have access to the objects themselves. Similar to what: model.objects.filter(name__icontains=word) ...
I imported all of our database to a new server. When I looked at the tables I see the indexes, but they all show a cardinality of 0. If I remove one index and add it back in, it triggers all the other indexes to run, but there's 180 tables. Is there a way to force all the tables to run their indexes? ...
Suppose I have a string "qwerty" and I wish to find the index position of character e in it. How do I do it in C? (In this case the index would be 2) I found strchr function but that returns a pointer to the character and not the index. Please help me out! Thanks, Boda Cydo. ...
Hey I am finishing up a small web-platform I have been doing in my spare time and am going to add a run once script that is executed at creation for each new webpage. The script will run code to restrict ftp access so that people cannot download the ftp includes, some of which contain sql details. What I was wondering was if adding bla...
I wrote a stored procedure with optional parameters. CREATE PROCEDURE dbo.GetActiveEmployee @startTime DATETIME=NULL, @endTime DATETIME=NULL AS SET NOCOUNT ON SELECT columns FROM table WHERE (@startTime is NULL or table.StartTime >= @startTime) AND (@endTIme is NULL or table.EndTime <= @endTime) I'm won...
Is it possible to create an index of a table based on substring of one or more field values in DB2 ? ...
Table_a = 7022536 rows Table_b (GTT) = 5601 rows Query: SELECT COUNT (a.ssn_head) FROM table_a a, table_b b WHERE b.hoh = a.head AND a.flag = 'Y'; takes 20+ seconds to bring 17214 records. Explain plan is: Plan hash value: 1901401324 -------------------------------------------------------------------------------- | Id |...
Hi, I want nutch to crawl abc.com, but I want to index only car.abc.com. car.abc.com links can in any levels in abc.com. So, basically, I want nutch to keep crawl abc.com normally, but index only pages that start as car.abc.com. e.g. car.abc.com/toyota...car.abc.com/honda... I set the regex-urlfilter.txt to include only car.abc....
Using EXPLAIN for the query below shows SELECT cha.cid AS cid, cha.data AS dl FROM cha, c_users WHERE uid = 808 AND cha.cid = c_users.cid; it does a full scan on cha table uses the multi column index(cid,uid) from c_users. Why doesn't it not use the primary key index from cha and rather does a full table scan. Is there a b...