Search Results

Search found 11 results on 1 pages for 'arthurprs'.

Page 1/1 | 1 

• Should i really use integer primary IDs?

  - by arthurprs

  For example, i always generate an auto-increment field for the users table, but i also specifies an UNIQUE index on their usernames. There is situations that i first need to get the userId for a given username and then execute the desired query. Or use a JOIN in the desired query. It's 2 trips to the database or a JOIN vs. a varchar index The above is just an example There is a real performance benefit on INT over small VARCHAR indexes? Thanks in advance!

  Read the article

• anonymous function variable scope [js, ajax]

  - by arthurprs

  $(".delete").click( function() { var thesender = this; $(thesender).text("Del..."); $.getJSON("ajax.php", {}, function(data) { if (data["result"]) $(thesender).remove(); // variable defined outside else alert('Error!'); } ); return false; } ); This can cause problems if user clicks on another ".delete" before the ajax callback is called?

  Read the article

• Simple/efficient text compression

  - by arthurprs

  What's the simplest, but efficient compression algorithm? Deflate, lzma, etc. aren't valid options. I need something that compiles really small, like: RLE, LZX, Huffman, etc.. Note: The data is 95% ASCII text

  Read the article

• library for simple GUI appications

  - by arthurprs

  I tried to use WTL, but i couldn't get it to work on VS2008 Express, there is any other option? I would like to test if any, before recur to the plain API :/ need to be small and have no external dependencies Thanks in advance!

  Read the article

• Minimalist Wiki like script

  - by arthurprs

  I'm trying to find a simple wiki like script to setup a personal directory, browser favorites simply doesn't do anymore and i have lots of small files on my flash drive Desired features file upload not bloated works on a common webhost (aka php) Thanks in advance

  Read the article

• Should I use integer primary IDs?

  - by arthurprs

  For example, I always generate an auto-increment field for the users table, but I also specify a UNIQUE index on their usernames. There are situations that I first need to get the userId for a given username and then execute the desired query, or use a JOIN in the desired query. It's 2 trips to the database or a JOIN vs. a varchar index. Should I use integer primary IDs? Is there a real performance benefit on INT over small VARCHAR indexes?

  Read the article

• How do I disable directory browsing?

  - by arthurprs

  I want to disable directory browsing of /galerias folder and all subdirectories Index of /galerias/409 * Parent Directory * i1269372986681.jpg * i1269372986682.jpg * i1269372988680.jpg

  Read the article

• Should i really use integer primary IDs [sql]

  - by arthurprs

  For example, i always generate an auto-increment field for the users table, but i also specifies an UNIQUE index on their usernames. There is situations that i first need to get the userId for a given username and then execute the desired query. Or use a JOIN in the desired query. It's 2 trips to the database or a JOIN vs. a varchar index The above is just an example There is a real performance benefit on INT over small VARCHAR indexes? Thanks in advance!

  Read the article

• Update all table rows but top N in Mysql

  - by arthurprs

  I was trying to run the following query UPDATE blog_post SET `thumbnail_present`=0, `thumbnail_size`=0, `thumbnail_data`='' WHERE `blog_post` NOT IN ( SELECT `blog_post` FROM blog_post ORDER BY `blog_post` DESC LIMIT 10) But Mysql doesn't allow 'LIMIT' in an 'IN' subquery. I think I can make a select to count the table rows and then make an ordered update limited by 'COUNT - 10', but I was wondering if there is a better way. Thanks in advance.

  Read the article

• Strange profiler behavior: same functions, different performances

  - by arthurprs

  I was learning to use gprof and then i got weird results for this code: int one(int a, int b) { return a / (b + 1); } int two(int a, int b) { return a / (b + 1); } int main() { for (int i = 1; i < 30000000; i++) { two(i, i * 2); one(i, i * 2); } return 0; } and this is the profiler output % cumulative self self total time seconds seconds calls ns/call ns/call name 48.39 0.90 0.90 29999999 30.00 30.00 one(int, int) 40.86 1.66 0.76 29999999 25.33 25.33 two(int, int) 10.75 1.86 0.20 main If i call one then two the result is the inverse, two takes more time than one both are the same functions, but the first calls always take less time then the second Why is that? Note: The assembly code is exactly the same and code is being compiled with no optimizations

  Read the article

• disable directory browsing [apache]

  - by arthurprs

  I want to disable directory browsing of /galerias folder and all subdirectories Index of /galerias/409 * Parent Directory * i1269372986681.jpg * i1269372986682.jpg * i1269372988680.jpg Thanks in advance

  Read the article

1