Search Results

Search found 4580 results on 184 pages for 'faster'.

Page 75/184 | < Previous Page | 71 72 73 74 75 76 77 78 79 80 81 82  | Next Page >

• Improve long mysql query

  - by John Adawan

  I have a php mysql query like this $query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10"; As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing. But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit. Let's discuss how we can improve on such long query.

  Read the article

• Improve long mysql query

  - by John Adawan

  I have a php mysql query like this $query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10"; As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing. But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit. Let's discuss how we can improve on such long query.

  Read the article

• What's behind the 'system' function in perl?

  - by JohnJohnGa

  i can thought that it will open a shell, execute the parameter (shell command) and return the result in a scalar. But, execute 'system' function in a perl script is faster than a shell command. It will call this command in C? If yes, what's the difference between rmdir foo and system('rmdir foo'); Thanks,

  Read the article

• design decision between array or object save in database

  - by justjoe

  i code some configuration setting. And need those values to be load, everytime my webapp start. yes, it's somekind autoload setting. But, right now, i have to choose between save it as object or array. is there any different between them when we save them in database ? which one is faster or maintainable or other pro and cons thanks

  Read the article

• What is a more efficient way in Python to return list elements which are not in a second list?

  - by Hobhouse

  Is there a faster way to do this in python? [f for f in list_1 if not f in list_2] list_1 and list_2 both consist of about 120.000 strings. It takes about 4 minutes to generate the new list.

  Read the article

• Performance Difference Between For and Foreach loop [closed]

  - by Asim Sajjad

  Possible Duplicates: In .NET which loop runs faster for or foreach c# for Vs foreach I want to know which is the best For loop or foreach loop ? Performance wise.

  Read the article

• Does variable name length matter for performance C#?

  - by MadBoy

  I've been wondering if using long descriptive variable names in WinForms C# matters for performance? I'm asking this question since in AutoIt v3 (interpreted language) it was brought up that having variables with short names like aa instead of veryLongVariableName is much much faster (when program is bigger then 5 liner). I'm wondering if it's the same in C#?

  Read the article

• How do make changes in drivers/etc/hosts take affect instantly with IE?

  - by wamp

  Firefox will notice this change immediately, but IE will need several minutes to take affect. Is there somehow I can make it work faster?

  Read the article

• How to copy a 110GB table with BLOBs from one schema to another on ORACLE

  - by simao

  Hello, I have a table containing 110GB in BLOBs in one schema and I want to copy it to another schema to a different table. I only want to copy a column of the source table so I am using an UPDATE statment, but it takes 2,5 hours to copy 3 GB of data. Is there a faster way to do this? Thank you

  Read the article

• Does the jQuery Paradigm go against Unit Testing or complement it?

  - by leeand00

  Yes, I am aware of QUnit, but with the jQuery Paradigm all about getting things done faster with less code, and is this some how opposed to a TDD Paradigm? Or does it complement it somehow?

  Read the article

• C: performance of assignments, binary operations, et cetera...

  - by Shinka

  I've heard many things about performance in C; casting is slow compared to normal assignments, functional call is slow, binary operation are much faster than normal operations, et cetera... I'm sure some of those things are specific to the architecture, and compiler optimization might make a huge difference, but I would like to see a chart to get a general idea what I should do and what I should avoid to write high-performance programs. Is there such a chart (or a website, a book, anything) ?

  Read the article

• Resort (reorder) table data

  - by Dave Jarvis

  What is the fastest way to reorder (resort) a table? In MySQL, you can do: CREATE TABLE table2 LIKE table1; INSERT INTO table2 SELECT * FROM table1 ORDER BY by name; DROP TABLE table1; RENAME TABLE table2 TO table1; What about PostgreSQL? Is there a faster way?

  Read the article

• does it makes sense to do SP for simple queries like select * from users

  - by Omu

  is it going to be faster if instead of doing select * from users where id = 1 or delete from users where id = 1 or select count(*) from users I would create a SP for it ?

  Read the article

• How to manually build mysql cache

  - by hamstar

  I have a table of over 150,000 rows of which most would be updated daily. I have mysql caching turned on so the pages load faster however everytime the database is updated the pages load slow again, which I assume is the cache building itself again. So at the moment I have resorted to doing a wget -m --delete-after http://localhost/ on the server however this takes about 4 hours to complete and moves something like 13 gig. Is there a better way to do this?

  Read the article

• Is a display list best for this? (OpenGL)

  - by user146780

  I'm rendering 2D polygons with the GLUTesselator the first time, then they are stored in a display list for subsequent use. I think VBO's might be faster, but since I can't access the stuff that the tesselator outputs, and since it uses mixes of gl_triangle, quad, strip etc, i'm not sure how I could do this, even though I would like to use VBO's once the GLUTesselator is done with them for optimal performance. Thanks

  Read the article

• .NET immutable object usage best practices? Should I be using them as much as possible?

  - by Daniel

  Say I have a simple object such as class Something { public int SomeInt { get; set; } } I have read that using immutable objects are faster and a better means of using business objects? If this is so, should i strive to make all my objects as such: class ImmutableSomething { public int SomeInt { get { return m_someInt; } } private int m_someInt = 0; public void ChangeSomeInt(int newValue) { m_someInt = newvalue; } } What do you reckon?

  Read the article

• How to convert a Java Long to byte[] for Cassandra?

  - by dfrankow

  Lazy programmer alert. :) Cassandra stores column values as bytes (Java example). Specifying a LongType comparator compares those bytes as a long. I want the value of a long into a Cassandra-friendly byte[]. How? I poked around for awhile. I think you people can help me faster.

  Read the article

• how to perform square root without using math module??

  - by kaki

  i want to find the square root of a number without using the math module,as i need to call the function some 20k times and dont want to slow down the execution by linking to the math module each time the function is called is there any faster and easier way for finding square root??

  Read the article

• 398 row datalist slowing down modal open????

  - by Jreeter

  Hey guys I got a weird issue.. I have a datalist that's only loaded on pageload it contains 2 columns a name and date and has 398 rows.. In IE 7 and above(and prob previous version) when I open a modal via a button click it takes almost 5 seconds to open. HOWEVER, if I do not bind this datalist it's MUCH faster.. Also this is only happening in IE, Chrome, Firefox and opera both open the modal instantly with the datalist binded... Josh

  Read the article

• jquery-like HTML parsing in Python?

  - by Roy Tang

  Is there any Python library that allows me to parse an HTML document similar to what jQuery does? i.e. I'd like to be able to use CSS selector syntax to grab an arbitrary set of nodes from the document, read their content/attributes, etc. The only Python HTML parsing lib I've used before was BeautifulSoup, and even though it's fine I keep thinking it would be faster to do my parsing if I had jQuery syntax available. :D

  Read the article

• Most Efficient way to get the <title> of a URL?

  - by rksprst

  It's simple to do a webrequest, get the page and parse the html to get the title of the page. But I'm wondering if there is a more efficient way that is faster, and doesn't require downloading the whole html?

  Read the article

• Jquery: get ancestors (or descendants) and self

  - by gsakkis

  One can use matchedset.find(selector) / matchedset.parents(selector) to get the descendants/ancestors of the current matched set filtered by a sealector, but that doesn't include the matched set itself (if it happens to match the selector too). Is there a better (more consise and/or faster) way to get it than matchedset.find(selector).add(matchedset.filter(selector)) and the respective for parents() ?

  Read the article

• alternate way for string replace and array

  - by Ronnie Chester Lynwood

  hello.. is there any way to replace titles faster then str_replace function? I've got a file that 2000 lines of array changes. that hurts my webpage thanks.

  Read the article

• How to disable Middleware and Request Context in some views.

  - by xRobot

  I am creating a chat like facebook chat... so in views.py of my Chat Application, I need to retrieve only the last messages every 3-4 seconds with ajax poll ( the latency is not a problem for me ). If I can disable some Middlewares and some Request Context in this view, the response will be faster... no ? My question is: Is there a way to disable some Middlewares and some Request Context in some views ?

  Read the article

• PHP: Fastest way possible to read contents of a file.

  - by SoLoGHoST

  Ok, I'm looking for the fastest possible way to read all of the contents of a file via php with a filepath on the server, also these files can be huge. So it's very important that it does a READ ONLY to it as fast as possible. Is reading it line by line faster than reading the entire contents? Though, I remember reading up on this some, that reading the entire contents can produce errors for huge files. Is this true?

  Read the article

< Previous Page | 71 72 73 74 75 76 77 78 79 80 81 82  | Next Page >