Re: Slow write to sqlite on usb sticks

Glad it worked for you Terry. Sometimes the performance hits on this stuff aren't obvious until you have to deal with slow i/o speeds. Pete lcSQL Software On Thu, Apr 26, 2012 at 7:29 PM, Terry Judd wrote: > > On 27/04/2012, at 3:37 AM, Peter Haworth wrote: > > Hi Te

Re: Slow write to sqlite on usb sticks

On 27/04/2012, at 3:37 AM, Peter Haworth wrote: Hi Terry, You can still do individual INSERTS, just need a few lines of extra code at the start and end of your code. Here's an amended version of your code with the BEGIN/ROLLBACK/COMMIT in place. Peter - using the BEGIN/COMMIT form seems

Re: Slow write to sqlite on usb sticks

Pete- Thursday, April 26, 2012, 4:36:24 PM, you wrote: > Once again, this varies form db to db. Even sqlite3 can now allow readers > while the db is locked by setting the Write Ahead Locking pragma. ...and don't even ask about how msAccess locks things... -- -Mark Wieder mwie...@ahsoftware.n

Re: filename path over local network

I just realized I was asking the wrong question. Rather than streaming the video, I simply have my stack copy the files from the server to the local computer. Just tried it successfully using the LC IDE to import a txt file onto a card as a field object. Now, to figure out how to get that path to

Re: Slow write to sqlite on usb sticks

Once again, this varies form db to db. Even sqlite3 can now allow readers while the db is locked by setting the Write Ahead Locking pragma. For mySQL, there is a LOCK and an UNLOCK command which allow you to lock individual tables for read and/or write access, as well as BEGIN and END, which lock

Re: filename path over local network

Thanks for responding, Bob. > If I understand you correctly, you want to connect to reference an image > file on a server. Yes. > I think this is a bad idea, but if your os has the share > mounted, just browse to the file and choose it. I think I already tried this, ie, by browsing to the jpg f

Re: filename path over local network

I just tested this. You can reference a file on a file server, but the volume must be mounted for the image file to work. I tried to reference the file by manually typing in the afp URL. (I assume it works the same way with a Windows share using SMB. To the OS X file system, once the volume is m

Re: filename path over local network

If I understand you correctly, you want to connect to reference an image file on a server. I think this is a bad idea, but if your os has the share mounted, just browse to the file and choose it. You will have to have that share mounted every time you open a card with that image though. It's b

filename path over local network

Hello All, All the wrong terminology I'm sure for something very basic. At my place of work, there's a server to which my computer can connect via those blue LAN cables. I know it can connect because I can navigate to it using the Windows OS navigator, for example, to transfer files back and fort

Re: Slow write to sqlite on usb sticks

Oh thanks. I was aware that beginning a transaction made the database writable by only the client who began the transaction, but does it lock people out of reads as well? In the past I would manually lock a database while inserting records or before doing a transactional update, so that I could

Re: Slow write to sqlite on usb sticks

I think you're using mySQL Bob? If so, be aware that BEGIN and END are also the means by which you lock the database. Doesn't matter too much with sqlite because it's basically a single user db but with multi user dbs like mySQL (actually just about any db other than sqlite), locking is a whole o

Re: Slow write to sqlite on usb sticks

Yes, transactions... good! I need to incorporate them into my app when I am ready to go into production (as if I will ever get to that point!). Bob On Apr 26, 2012, at 2:38 PM, Terry Judd wrote: > Wow, thanks Pete - I'll definitely give this method a try. > > Terry.. __

Re: Slow write to sqlite on usb sticks

Wow, thanks Pete - I'll definitely give this method a try. Terry.. On 27/04/2012, at 3:38 AM, "Peter Haworth" wrote: > Hi Terry, > You can still do individual INSERTS, just need a few lines of extra code at > the start and end of your code. Here's an amended version of your code > with the BEG

Re: Building Win standalones on a Mac

You saved my life Man! Just changed the field characteristics of the app icon and the doc icon flds: i.e. deselected "lock text" and selected "focusable". A wonderful trick that saved me a lot of aggro. Thanks a million. Hi Richmond, I have the same problem. I have modified the standalone

Re: Building Win standalones on a Mac

"The 'mcstandalonebuilder.rev' file cannot be found. It needs to be put into the mccomponents' folder at the same level as the 'mctools' stack." Joy! NONE at all. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to su

Re: Casey is now in the App Store

On 4/26/12 10:26 AM, Bob Sneidar wrote: After reading the directions, I am still a little sketchy as to how the parrot "helps" exactly. I thought he just poops on cards and messes up the order? Yes. "Help" is a euphemism. There's one instance where sometimes it can work to your advantage. If y

Re: Building Win standalones on a Mac

I have tried building Windows standalones using 4.5 (which, until I make some money out of the thing is as far as I can go) on Mac, Linux and Win with no joy. I have no problem with 4.0; except that it mucks around with PNG images that have transparent areas. So . . . Does anybody have any a

Re: Slow write to sqlite on usb sticks

Hi Terry, You can still do individual INSERTS, just need a few lines of extra code at the start and end of your code. Here's an amended version of your code with the BEGIN/ROLLBACK/COMMIT in place. put the cUpdateMessagesSQL of this cd into tSQL # my insert statement put revOpenDatabase("sqlite",

Re: Building Win standalones on a Mac

Richmond- Thursday, April 26, 2012, 12:40:53 AM, you wrote: > The really odd thing is that I tried to build a Windows standalone in > VirtualBox running > Windows XP (LC 4.5) and got the same problem about doc icons. I just recently started having similar problems. Building a Windows standalone

Re: Time-Stamping Demo programs #2

Yeah CCC has saved my buttocks a few times, and I use it a lot, so I "donated" a few times already. Bob On Apr 26, 2012, at 1:23 AM, Kay C Lan wrote: > On Wed, Apr 25, 2012 at 12:11 AM, J. Landman Gay > wrote: > >> Graphic Converter does that and its author has been supporting himself for >>

Re: Time-Stamping Demo programs #2

My approach to buying shareware is if I try something and it helps me do something I need to do, I go buy it, even if I do not need to do that thing again. It's a matter of integrity to me. I think there are a lot of people like that, but I know there are also a lot of other people who think if

Re: [OT] ROR Difference between has one and belongs to one

Thanks Mark! That helps a lot! I will forward this to the web guy. Bob On Apr 25, 2012, at 7:19 PM, Mark Wieder wrote: > Bob- > > Tuesday, April 24, 2012, 9:31:05 AM, you wrote: > >> Hi. For anyone who has experience using Ruby on Rails, I have a >> friend who is redesigning the corporate we

Re: Casey is now in the App Store

After reading the directions, I am still a little sketchy as to how the parrot "helps" exactly. I thought he just poops on cards and messes up the order? Bob On Apr 25, 2012, at 7:03 PM, Mark Smith wrote: > > J. Landman Gay wrote >> >> Casey's Solitaire has migrated to the App Store. :) If

Re: Building Win standalones on a Mac

Richmond, Why is that odd? Same Standalone Builder. Same scripts. Same bugs. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 We will have room for new projects aft

Re: Slow write to sqlite on usb sticks

Interesting stats Kay. I have a feeling that not all USB memory sticks are equal either. The no-name ones we give out to students (8 GB) are relatively cheap and definitely don't perform as well as a couple of name brand sticks I have lying around. I don't think we even get close to 11 MB/s out

Re: Slow write to sqlite on usb sticks

Hi Terry, Strange you should raise this as I was just wondering myself why SD cards are so slow when they have no mechanical parts. You don't mention if the HD you were using was internal or external, but on my own system I get the following benchmarks: Internal HD - 99 MB/s External eSATA (via c

Re: Time-Stamping Demo programs #2

On Wed, Apr 25, 2012 at 12:11 AM, J. Landman Gay wrote: > Graphic Converter does that and its author has been supporting himself for > years with it, it's hugely popular. It isn't limited in any way. > > I don't know that Mike Bombich supports himself off the 'donations' to Carbon Copy Cloner, but

Re: Building Win standalones on a Mac

The really odd thing is that I tried to build a Windows standalone in VirtualBox running Windows XP (LC 4.5) and got the same problem about doc icons. When I selected the .ico file I have for my standalone as the doc icon as well it did not 'take'. Hi Richmond, I have the same problem. I ha