Hi guys,

I'm working on a tableselection app I want to work with notecaddy.

I've tried StdOuttoVar functions by Sean in the AHK forum: http://www.autohotkey.com/forum/view...ht=stdouttovar

And also SQL using RAM by mehere: http://www.autohotkey.com/forum/view...=sql+using+ram

I have not yet tried cmdret but I think that will be similar to stdouttovar.

Some of the strings in the output are >10million characters.

The query takes 30-40 ms in PgAdmin but heaps longer using the above tools. SQL_ram is fastest (~200ms), but its horrible for multiple tables as each extra table seems to add to a bottleneck because of the fact that it uses the clipboard to transfer content. StdOutToVar takes ~1sec to return the result.

Anyway I'm guessing someone can shed some light on this issue as I'm sure its not uncommon!

tx for reading

also if anyone uses AHK for poker stuff and has skype feel free to add me. poisonjuice1

is there a way to test how long it takes to run a piece of code in AHK? Set up stopwatches for major tasks and see what is taking the biggest part of that 1sec

yeah I set up timers within the function to see that, I should have mentioned this in OP sorry.

The section that is taking the longest (>90% of the time) is this block:

thanks for replying!

I haven't used AHK in several years but if I had to guess I'd say the fact that you're using regex is something that could be killing performance. Speed is important in any app and I've been optimizing NoteCaddy's performance for around 2 years so I have made some discoveries most notably that even the most ghetto string parsing (substring, indexOf etc) is way faster than regex

Anyways it doesn't look like you need it based on your posts but in case you're not sure how to decipher what NC stores in the database, it's discussed here http://assaultwareforums.com/showthr...ighlight=split

thanks one of my good friends actually posted that thread btw I'm thrillkill on your forum. I'm sure you'd be the guru at this kind of stuff considering how solid notecaddy is, keep up the great work!

Also, the block using regex is never really entered because I've got bStream set to 0. So its specifically something to do with the readfile dllcall I think....

If a reputable ahk guy knows how to help explain a solution/ give a solution but doesn't feel incentivised to help me then plz don't hesitate to pm me with a quote or something.

looks like calling varsetcapacity might not be needed inside the loop? that and numput are presumably what's taking up the all time. hard to guess without seeing it run and having stuff explained more!

to get around the clipboard issue I might suggest running my file-based psql function, but from a ramdisk (presumably we can still make those in windows!).

Hey dave,

I think my main problem is I didn't code the function, I just found it on the AHK forums and the creator is MIA. I quickly tried removing varsetcapacity and just calling it once before the loop but that made the function return empty strings.

thanks for the suggestion, I didn't even know what a ramdisk was but I've found a youtube tut

I followed links to try and find your script but the links were dead on the AHK forum, do you have a current link for it? cheers!

i would post your question on the ahk help forums or in the thread of the code youre using

hey greg

I did both before coming here, as well as asking in the ahk chatroom a few times. The creator seems MIA though unfortunately.

UPDATE: thanks to _dave_ for his idea on using a ramdisk + his psql function the speed has been reduced to 155-345 ms for 25million characters Really appreciate the suggestion dave, thanks!