Search Results

Search found 23005 results on 921 pages for 'query cache'.

Page 28/921 | < Previous Page | 24 25 26 27 28 29 30 31 32 33 34 35  | Next Page >

• Why is doing a top(1) on an indexed column in SQL Server slow?

  - by reinier

  I'm puzzled by the following. I have a DB with around 10 million rows, and (among other indices) on 1 column (campaignid_int) is an index. Now I have 700k rows where the campaignid is indeed 3835 For all these rows, the connectionid is the same. I just want to find out this connectionid. use messaging_db; SELECT TOP (1) connectionid FROM…

  Read the article

• When should we delete the cache data in an iPhone apps?

  - by athanhcong

  Hi all, We often cache image and data to improve our iPhone app's performance. But what strategy do you use to manage the cache data, such as delete or update it? When should we trigger to delete the cache data: when the iPhone apps starts, or quits, or in idle time?

  Read the article

• What could be adding "Pragma:no-cache" to my response Headers? (Apache, PHP)

  - by Daniel Magliola

  I have a website whose maintenance I've inherited, which is a big hairy mess. One of the things i'm doing is improving performance. Among other things, I'm adding Expires headers to images. Now, there are some images that are served through a PHP file, and I notice that they do have the Expires header, but they also get loaded every time. Looking…

  Read the article

• How to force HttpWebRequest to use cache in ASP.NET environment?

  - by piotrsz

  In my ASP.NET app I use HttpWebRequest for fetching external resources which I'd like to be cached. Consider the following code: var req = WebRequest.Create("http://google.com/"); req.CachePolicy = new HttpRequestCachePolicy(HttpRequestCacheLevel.CacheIfAvailable); var resp = req.GetResponse(); Console.WriteLine(resp.IsFromCache); var answ = (new…

  Read the article

• Why is doing a top(1) on an indexed column in mssql slow?

  - by reinier

  I'm puzzled by the following. I have a DB with around 10 million rows, and (among other indices) on 1 column is an index. Now I have 700k rows where the campaignid is indeed 3835 For all these rows, the connectionid is the same. I just want to find out this connectionid. use messaging_db; SELECT TOP (1) connectionid FROM …

  Read the article

• Coherence Query Performance in Large Clusters

  - by jpurdy

  Large clusters (measured in terms of the number of storage-enabled members participating in the largest cache services) may introduce challenges when issuing queries. There is no particular cluster size threshold for this, rather a gradually increasing tendency for issues to arise. The most obvious challenges are that a client's…

  Read the article

• In Symfony how can you instantely cache the routing.yml?

  - by Mark

  I have a file located at [application]/config/routing.yml, when I change something in there, the changes aren't active. This probably has to do with the cache as when I go into that directory [cache]/[application]/prod/config the currently active file can be seen config_routing.yml.php. The lifetime of the cache is generally 86400…

  Read the article

• Insert new row with data computed from other rows

  - by Tyler McHenry

  Suppose I have a MySQL table called MyTable, that looks like this: +----+------+-------+ | Id | Type | Value | +----+------+-------+ | 0 | A | 1 | | 0 | B | 1 | | 1 | A | 2 | | 1 | B | 3 | | 2 | A | 5 | | 2 | B | 8 | +----+------+-------+ And, for each Id, I want to insert a new…

  Read the article

• Does the symfony cache file system handle ext2 32000 files in the same directory limitation ?

  - by belaz

  Does the symfony cache system handle ext2 32000 files in the same directory limitation ? I have 80000 users and i want to cache their profiles but do symfony cache system handle the ext2 limitation ? i'm also posting for the others who will face the same problem.

  Read the article

• Global Cache CR Requested But Current Block Received

  - by Liu Maclean(???)

  ????????«MINSCN?Cache Fusion Read Consistent» ????,???????????? ??????????????????: SQL> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production…

  Read the article

• Clearing System.Web.Cache

  - by Han Cheng

  1: System.Collections.IDictionaryEnumerator enumerator = context.Cache.GetEnumerator(); 2: while (enumerator.MoveNext()) 3: { 4: context.Cache.Remove(enumerator.Key.ToString()); 5: }

  Read the article

• Configuring UCM content cache invalidation for a custom portal application

  - by Martin Deh

  Recently, I had blogged about enabling the UCM content cache invalidator for Spaces (found here).  This can also be enabled for a WebCenter Custom Portal application as well.  The much overlooked setting is done through the Content Repository connection definition in the JDeveloper Application Resources section. …

  Read the article

• Optional parameters with named query in Hibernate?

  - by Ickster

  Is there any way to specify optional parameters (such as when search parameters are provided from a form and not all parameters are required) in a named query when using Hibernate? I'm using a native SQL query, but the question is probably applicable to named HQL queries as well. I'm pretty sure the answer to this is 'no',…

  Read the article

• hierachical query to return final row

  - by jeff

  I have a hierarchical query that doesn't return an expected row (employee badge = 444). TABLE: hr_data badge fname supervisor_badge 111 Jeff 222 222 Joe 333 333 John 444 444 Tom 444 SQL: SELECT CONNECT_BY_ISCYCLE As IC, badge, fname, supervisor_badge FROM hr_data START WITH badge…

  Read the article

• Using Treelist Values to Query a Sitecore Item

  - by kirk.burleson

  I have an item named All Recipes that contains recipes named R1, R2, and R3. I have another item named My Recipes that has a treelist field named Recipes and it contains selected values R2 and R3 from the All Recipes item. The query I'm trying to write is for the Items field of an RSS Feed. What is the query syntax to show…

  Read the article

• fluent nhibernate named-query without using hbm file for the map

  - by user57555

  I am needing to create named-query, and use it with one of the maps, that i currently have defined as a fluent map. is it possible to continue using the fluent map, and be able to create the named-query dynamically in code? or, is switching to a hbm map the only option?

  Read the article

• Problemwit sql query

  - by phenevo

  Hi, I've got query: INSERT INTO [Tasks] ([LoginName] ,[Type] ,[Filter] ,[Dictionary] ,[Description]) Select N'Anonymous',4,'SomeTable.targetcode in (select Code from cities where countrycode in ('TN')) and SomeTable.SomeValue in ('13','15')',3,N'Cities from tunis'…

  Read the article

• MySQL query from subquery not working

  - by James Goodwin

  I am trying to return a number based on the count of results from a table and to avoid having to count the results twice in the IF statement I am using a subquery. However I get a syntax error when trying to run the query, the subquery I have tested by itself runs fine. Any ideas what is wrong with the query? The…

  Read the article

• Using Hibernate to do a query involving two tables

  - by Nathan Spears

  I'm inexperienced with sql in general, so using Hibernate is like looking for an answer before I know exactly what the question is. Please feel free to correct any misunderstandings I have. I am on a project where I have to use Hibernate. Most of what I am doing is pretty basic and I could copy and modify. Now…

  Read the article

• Issues with Rails 3.1 API with Query String to Create action on Mac OSX Mountain Lion

  - by hjaved

  Hi I've been stuck on this problem for a while and would appreciate your help. I'm writing an API to allow an external source like a Browser Query String or a smartphone to enter some model User info in a form and hit the User create action to write the data to the db. Please tell me what I'm doing wrong with the…

  Read the article

• Convert SQL query to Ruby help

  - by Verloren

  Hey all, I need to query my database table to find which employee has the most support tickets related to them. I can do this just fine using this MySQL query: SELECT employee_id, COUNT(id) AS number_of_tickets FROM tickets GROUP BY employee_id ORDER BY number_of_tickets DESC LIMIT 1; How would write this in…

  Read the article

• Any way to speed up this hierarchical query?

  - by RenderIn

  I've got a serious performance problem with a hierarchical query that I can't seem to fix. I am modeling several organization charts in my database, each representing a virtual organization within our company. For example, we have several temporary committees that are created from time to time and there may be…

  Read the article

• join query in mysql cursor

  - by parag

  As the title describes all we can declare cursor like this DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1; Can we use join query instead off simple query?

  Read the article

• How to update multiple rows with one single query

  - by xRobot

  I use Postgresql + PHP. Say I have this table: Books ( id, title, year ) and this array of titles in PHP: $titles = array ("bible","kafka","Book of Eli"); now I want update all rows where the title is in the $titles array above. So I need a query like this: UPDATE books SET year = '2001-11-11' WHERE…

  Read the article

• Selecting from 2 tables in a single query

  - by duder

  I have a table that I'm querying for value 43 in the second field and I return the value of the third field SELECT t1_field3 FROM table1 WHERE t1_field2=43 this returns 19, 39,73 t1_id t1_field2 t1_field3 ----- --------- --------- 1 43 19//// 2 43 …

  Read the article

< Previous Page | 24 25 26 27 28 29 30 31 32 33 34 35  | Next Page >