Re: Database: INSERTS, speed and primary keys

Thanks for that Monte, On 27 September 2010 13:44, Monte Goulding wrote: > UNIQUE INDEX `mykey` (`name`, `type`, `location`, `handler_num`) ); > > Or you can use a separate Create Unique Index statement. > OK - will have to read up more on Indexes - I thought they were just for speeding up sea

Re: Database: INSERTS, speed and primary keys

Try: -- - -- Table `handler` -- - CREATE TABLE IF NOT EXISTS `handler` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `type` VARCHAR(255) NOT NULL , `location` VARC

Re: Database: INSERTS, speed and primary keys

OK - not getting very far with that - Google is not my friend :) Can you give me an idea of what the CREATE statement would look like? CREATE TABLE 'handler' ( > 'name' VARCHAR(255) NOT NULL, 'type' VARCHAR(255) NOT NULL, > 'location' VARCHAR(255) NOT NULL, > 'handler_num' INTEGE

Re: Database: INSERTS, speed and primary keys

> HI Monte - hows down-under :) Getting better all the time ;-) > > Only by making the primary key = "name,type,location,hnum" instead of "id" > woudl you get a fast normalisation of the data inserted. You can create an secondary key for those fields and still use your primary key auto-incremen

Re: Database: INSERTS, speed and primary keys

HI Monte - hows down-under :) On 27 September 2010 11:31, Monte Goulding wrote: > > I haven't yet used SQLYoga but I'm sure Trevor has this all worked out. > SQLite will handle the auto increment of integer primary keys when you > INSERT without an ID field and then you query > put revDataFromQue

Re: Database: INSERTS, speed and primary keys

Hi David > > However if I uses a > surrogate primary key (ie the usual auto-incremented numeric id field), for > each updated record I need to check first whether it is already in the > database before adding it - this is a lot of overhead in terms of finding > the ids based on other fields. I ha

Database: INSERTS, speed and primary keys

I've spent the weekend refreshing on databases. I'm using LiveCode and also Trevor's fabulous sqlYoga, and beginning to realise how little I know about databases! The question I've got is about the database schema design and optimising it for the speed of adding records. * E

RE: Object Speed ?

: Re: Object Speed ? Hi Shani, > HI, > Thanks > > It works same as i mention before. > http://www.4shared.com/file/iyM6-FY7/test.html > > > Example:- > like consider that I have two object (car) they both start same time. One is > moving on speed 75km/h and other

Re: Object Speed ?

Hi Shani, > HI, > Thanks > > It works same as i mention before. > http://www.4shared.com/file/iyM6-FY7/test.html > > > Example:- > like consider that I have two object (car) they both start same time. One is > moving on speed 75km/h and other is on 120 km/h,

RE: Object Speed ?

HI, Thanks It works same as i mention before. http://www.4shared.com/file/iyM6-FY7/test.html Example:- like consider that I have two object (car) they both start same time. One is moving on speed 75km/h and other is on 120 km/h, the car which is on 120 km/h reach before and other one reach

Re: Object Speed ?

Hi Shani, > HO can i change the speed of different objects. > > move graphic xyz from the loc of grc xyz to the loc of grc ("xz") in 2 > seconds. > > > > When I apply this command this wait for 2 second then go toward the goal, > but I need it like whe

Object Speed ?

HO can i change the speed of different objects. move graphic xyz from the loc of grc xyz to the loc of grc ("xz") in 2 seconds. When I apply this command this wait for 2 second then go toward the goal, but I need it like when I have 4 objects and four different goal. It g

Re: adjusting speed of set arcangle of graphic

Malte, Your second script solution is brilliant! Many thanks. -- Nicolas Cueto ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runre

Re: adjusting speed of set arcangle of graphic

Hi Nicolas, > Instead of the arcangle increasing, how could I use AE to make it > decrease? So that the circle disappears. The good part about the easing functions is that they are agnostic towards order of values. They always calculate the correct value at the given elapsed time. A few minor ch

Re: adjusting speed of set arcangle of graphic

On Wed, Mar 17, 2010 at 11:00 AM, Nicolas Cueto wrote: > Malte, thank you... and a further AE question! (Apologies to the list.) No apology needed, at least as far as I am concerned. AE is a Rev development tool and so this is a perfect place for a discussion of it's abilities. Cheers, Sarah ___

Re: adjusting speed of set arcangle of graphic

Malte, thank you... and a further AE question! (Apologies to the list.) Instead of the arcangle increasing, how could I use AE to make it decrease? So that the circle disappears. I tried reversing the aeEaseIn function's start/end values and setting a negative exponent value, but the only think I

Re: adjusting speed of set arcangle of graphic

Hi Nicolas, what you would need to do to make it accurate on all machines is calculate the value for the arcangle as it *should* be at the current time stamp. that way it might look a bit jerky on slower machines, though I doubt that would be noticeable. I am afraid I´ll need to blow my own hor

adjusting speed of set arcangle of graphic

arcangle draw speed was just right; but on my client machines, noticeably slower. I guess the cause is the older CPU or insufficient memory of the client machines. If so, is there a way of coming up with a measurement that'll adjust the variable gArcAngleDelay relative to the processing spe

Re: Datagrid: speed question related to how it is working under the hood?

m record, does the underlying library only update the display >> associated with this one record, or does the library redraw all the >> currently displayed records? >> Would I be any better off speed wise directly setting the images / >> metadata >> of records using ove

Re: Datagrid: speed question related to how it is working under the hood?

aw all the currently displayed records? Would I be any better off speed wise directly setting the images / metadata of records using over using built in datagrid api calls? The data grid will only redraw the row you altered. If the row isn't visible on screen then an offscreen control is crea

Datagrid: speed question related to how it is working under the hood?

I've got a question about how commands like "set the dgDataOfIndex" work under the hood, and whether there are occasions where you would get speed increases by directly setting the value of an individual control in a record view. *First an introduction:* I've got a datagrid fo

Re: datagrid speed problem

On Sep 17, 2009, at 5:55 AM, Beat Cornaz wrote: I am on daily digest for the user group, so I cannot see any response until this afternoon, but I have found that when I add one of the substacks with a datagrid to the GLX framework, the speed is up to normal again. I get now the same speed

Re: datagrid speed problem

Hi Trevor, I am on daily digest for the user group, so I cannot see any response until this afternoon, but I have found that when I add one of the substacks with a datagrid to the GLX framework, the speed is up to normal again. I get now the same speed results as with the 'Test

Re: datagrid speed problem

Addendum : maybe I should mention that in the 'General pane' of the 'Standalone Settings' I use 'Select inclusions for the standalone application' and do NOT use the 'Search for required inclusions when saving the standalone application'. IMHO the normal revdatagridLib does not get found

Re: Datagrid speed problem

aking a standalone yields a version where the datagrids again do not work. If I include the revdatagridLib as a substack of my Splash (mainstack), then in the standalones, the datagrids do work, but slow. I started to use the GLX framework and I will move this project into the GLX framework

Re: Datagrid speed problem

Task4 cr Client3 tab Task1 tab Task2 tab Task3 The speed difference was quite big. Is it possible that your original data grid had some custom columns or scripts that run when you test that aren't present in the newly made data grid? Trevor, once again, thanks a lot for your patience

Re: Datagrid speed problem

Trevor wrote ; >I would need to see some code to get an idea of what might be the >cause. Can you provide the relevant portions and look for any >differences there might be between what is going on with the main >program data grid and the speed test data grid? I will check int

Re: Datagrid speed problem

Jerry's right - tRev is a non-invasive, fast, clean, mean coding machine. I use it exclusively. And the support is awesome. you should check it out. - Stephen Barncard San Francisco http://houseofcubes.com/disco.irev 2009/9/16 Jerry Daniels > Beat, > > If, as you said,

Re: Datagrid speed problem

Beat, If, as you said, you don't like the Rev Script editor in 3.5, you might check out tRev. It might be more to your liking. On the other hand, you might not! Good luck with your grids either way. Link about tRev below. Best, Jerry Daniels Watch tRev - The Movie http://reveditor.com/trev

Re: Datagrid speed problem

Hi all and Beat and Trevor :-) On Sep 16, 2009, at 5:30 AM, Beat Cornaz wrote: ... Another problem which might be associated with it is the following : I have originally started this project in rev 2.9 and only when the datagrids came along I upgraded to rev. 3.5 (because I totally dislike

Re: Datagrid speed problem

On Sep 16, 2009, at 5:30 AM, Beat Cornaz wrote: Hi group & Trevor :-) Hi Beat :-) I have a significant speed difference in my datagrids. I noticed that the datagrids behave slow in my project. So I did a test and created a new main stack (test Speed) with a similar datagrid (

Datagrid speed problem

Hi group & Trevor :-) I have a significant speed difference in my datagrids. I noticed that the datagrids behave slow in my project. So I did a test and created a new main stack (test Speed) with a similar datagrid (same number of columns and labels) and ran the same two sripts I us

Re: Graphic speed comparison between webLets and desktop

Message: 7 Date: Thu, 10 Sep 2009 12:53:30 -0700 (PDT) From: BNig Subject: Re: Graphic speed comparison between webLets and desktop stacks To: use-revolution@lists.runrev.com Message-ID: <25389915.p...@talk.nabble.com> Content-Type: text/plain; charset=us-ascii Jim, one funny t

Re: Graphic speed comparison between webLets and desktop stacks

illisecond you go up to 1500 again. So there is more going on on the Mac then meets the eye. By contrast I did not manage to speed up the send in time handler, maybe someone has an idea. regards Bernd James Hurley wrote: > >> >> Message: 10 >> Date: Wed, 9 Sep 2009 14:54:0

Re: Graphic speed comparison between webLets and desktop stacks

Message: 10 Date: Wed, 9 Sep 2009 14:54:01 -0700 (PDT) From: SparkOut Subject: Re: Graphic speed comparison between webLets and desktop stacks To: use-revolution@lists.runrev.com Message-ID: <25373791.p...@talk.nabble.com> Content-Type: text/plain; charset=us-ascii James Hurley

Re: Graphic speed comparison between webLets and desktop stacks

yourself on the desktop using the stack: >> >> go url "http://jamesphurley.on-rev.com/OnRevGraphicTimer.rev"; >> >> And on the Web, go to >> >> http://jamesphurley.on-rev.com/OnRevTimer/test.html >> >> The stack is a little busy.

Re: Graphic speed comparison between webLets and desktop stacks

l "http://jamesphurley.on-rev.com/OnRevGraphicTimer.rev"; > > And on the Web, go to > > http://jamesphurley.on-rev.com/OnRevTimer/test.html > > The stack is a little busy. Jim Hurley > > (P.S. On the third card of the stack above I added is a simulation of > planeta

Re: Graphic speed comparison between webLets and desktop stacks

Someone at the conference asked about this speed issue (slow on the desktop--much faster on the web) but I couldn't hear the answer, only that it sounded like it was Kevin who responded. I suspect it must be a matter of timing of the screen refresh rate. But I have no

Graphic speed comparison between webLets and desktop stacks

ints: (1) Use a "Send message in x millisec" to cycle recursively through the points using x to control speed. (Asynchronous--i.e. allows for concurrent message sending) (2) Use a simple repeat loop, using a "Wait x millisec" between repeat to control speed (Not asynchr

On-Rev Server impressive speed improvment !

Hi All ! Seems that the last version of the on-rev server works, in average, about 15 times faster than the previous one :-) Anyone to confirm ? Kind Regards, -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___

Re: Any thoughts on speed limitations of Revlet?

Message: 15 Date: Thu, 30 Jul 2009 05:38:13 -0700 (PDT) From: capellan Subject: Re: Any thoughts on speed limitations of Revlet? To: use-revolution@lists.runrev.com Message-ID: <24737617.p...@talk.nabble.com> Content-Type: text/plain; charset=us-ascii Hi Jim, This revlet works great

Re: Any thoughts on speed limitations of Revlet?

://www.nabble.com/Any-thoughts-on-speed-limitations-of-Revlet--tp24654744p24737661.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe

Re: Any thoughts on speed limitations of Revlet?

://www.nabble.com/Any-thoughts-on-speed-limitations-of-Revlet--tp24654744p24737617.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe

Re: Any thoughts on speed limitations of Revlet?

ran much too fast. > That was best done by adding another preference. > > Set the Fast/Slow speed to about 45 and the Short/Long roll to .998 > > The new web url is > > http://jamesphurley.on-rev.com/NineBall2/test.html > > > Note the 2. > > This resolves th

Re: Any thoughts on speed limitations of Revlet?

I should have reminded everyone that Scott Rossi did a graphics remake of the Nine Ball stack: those nice shinny balls and the wood grained table are his. (Well, my design of the circular black pockets survived. I'm so proud.) I am astonished at how smoothly and effectively this move to th

Re: Any thoughts on speed limitations of Revlet?

There's a space between 'splash' and '21' the needs to be removed from the URL. Bernard On Mon, Jul 27, 2009 at 12:27 PM, Richmond Mathewson wrote: >> http://splash 21.on-rev.com/plugin/test.irev >> >> > Not so good; Safari can’t find the server.

Re: Any thoughts on speed limitations of Revlet?

splash21 wrote: So far the plugin looks pretty damn good and I imagine it will only get better with the next release. I've uploaded the Air Traffic Control game as a revlet and a quick animation stack and I like what I'm seeing! http://splash21.on-rev.com/ATC/ATC.irev Worked extremely well (we

Re: Any thoughts on speed limitations of Revlet?

So far the plugin looks pretty damn good and I imagine it will only get better with the next release. I've uploaded the Air Traffic Control game as a revlet and a quick animation stack and I like what I'm seeing! http://splash21.on-rev.com/ATC/ATC.irev http://splash 21.on-rev.com/plugin/test.ir

Re: Any thoughts on speed limitations of Revlet?

With Vista and Chrome, even the first shot fired smoothly - plays really well. Terry Judd wrote: On 27/07/09 9:39 AM, "Mark Smith" wrote: Also here, on 2.2Ghz intel PB/Safari...apart from the first shot when the plug-in is first loaded. This was my experience also - first shot was

Re: Any thoughts on speed limitations of Revlet?

Message: 6 Date: Sun, 26 Jul 2009 11:21:06 +1000 From: Sarah Reichelt Subject: Re: Any thoughts on speed limitations of Revlet? To: How to use Revolution Message-ID: Content-Type: text/plain; charset=ISO-8859-1 On Sun, Jul 26, 2009 at 1:48 AM, James Hurley> wrote: (SNIP)

Re: Any thoughts on speed limitations of Revlet?

works great here, safari on mac os 10.5 intel core 2 duo On Sun, Jul 26, 2009 at 9:31 PM, Sarah Reichelt wrote: >> Your recipe for putting a stack on the web worked like a charm. Thanks! > > Cool :-) > > >> Unfortunately, if Richard is right about the bumpy behavior being  "natural >> by-product

Re: Any thoughts on speed limitations of Revlet?

> Your recipe for putting a stack on the web worked like a charm. Thanks! Cool :-) > Unfortunately, if Richard is right about the bumpy behavior being  "natural > by-product of running inside the browser" , it does not look good for > porting games to a revlet. > Take a look at Nine Ball on the

Re: Any thoughts on speed limitations of Revlet?

> I am puzzled, Sarah, when you say that the mouseMove stack works at full > speed and then you say that it is not great. (And you speak of the torch. > Did you mean the winter scene of my barn?) Maybe you mean it runs at full > speed but is bumpy? Did you find the torch image breaking

Re: Any thoughts on speed limitations of Revlet?

On 27/07/09 9:39 AM, "Mark Smith" wrote: > Also here, on 2.2Ghz intel PB/Safari...apart from the first shot when > the plug-in is first loaded. This was my experience also - first shot was really jerky but the rest were smooth and fast. Terry... > > Best, > > Mark > > On 27 Jul 2009, at 00:

Re: Any thoughts on speed limitations of Revlet?

Jim- Here as well, Firefox on OSX Leopard intel and Firefox XP. -- -Mark Wieder mwie...@ahsoftware.net ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription prefe

Re: Any thoughts on speed limitations of Revlet?

Also here, on 2.2Ghz intel PB/Safari...apart from the first shot when the plug-in is first loaded. Best, Mark On 27 Jul 2009, at 00:28, stephen barncard wrote: NINE BALL looks and works great here. Mac G5 dual 2.5 ghzAwesome ballistics and graphics. - Stephen B

Re: Any thoughts on speed limitations of Revlet?

NINE BALL looks and works great here. Mac G5 dual 2.5 ghzAwesome ballistics and graphics. - Stephen Barncard San Francisco http://barncard.com 2009/7/26 James Hurley > >> > Unfortunately, if Richard is right about the bumpy behavior being "natural > by-product of

Re: Any thoughts on speed limitations of Revlet?

Message: 6 Date: Sun, 26 Jul 2009 11:21:06 +1000 From: Sarah Reichelt Subject: Re: Any thoughts on speed limitations of Revlet? To: How to use Revolution Message-ID: Content-Type: text/plain; charset=ISO-8859-1 On Sun, Jul 26, 2009 at 1:48 AM, James Hurley> wrote: (SNIP)

Re: Any thoughts on speed limitations of Revlet?

ngs that the calculational parts (calculating the positions and velocities of all the balls and determining the new positions and velocities aftercollisions) run very well in Safari. But the motion of the balls is very stuttered. It runs at full speed, that is it takes the same time t

Re: Any thoughts on speed limitations of Revlet?

calculational parts (calculating the positions and velocities of all the balls and determining the new positions and velocities after collisions) run very well in Safari. But the motion of the balls is very stuttered. It runs at full speed, that is it takes the same time to execute one &quo

Re: Any thoughts on speed limitations of Revlet?

Message: 5 Date: Sat, 25 Jul 2009 18:05:53 -0700 From: Richard Gaskin Subject: Re: Any thoughts on speed limitations of Revlet? To: How to use Revolution Message-ID: <4a6babf1.2030...@fourthworld.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed James Hurley wrote: Be

Re: Any thoughts on speed limitations of Revlet?

tland, a torch) carrying that script breaks up >>> on  the screen, i.e. the image breaks up into two separate parts. Odd. >> >>  I tested your stack Jim. It was very interesting as it worked at full >> speed when running in the browser but from the files on my desktop. W

Re: Any thoughts on speed limitations of Revlet?

James Hurley wrote: Before I begin to dream about the potential of Revlet, I would like to have some idea about the potential, particularly the speed in running graphics. I haven't tested graphics operations, and would be interested to hear of any differences from those. But FWIW,

Re: Any thoughts on speed limitations of Revlet?

est.rev"; Not only does the "mouseMove" handler run lethargically, but the image (a flashlight, or up in Scotland, a torch) carrying that script breaks up on the screen, i.e. the image breaks up into two separate parts. Odd. I tested your stack Jim. It was very interesting

Re: Any thoughts on speed limitations of Revlet?

Move" handler run lethargically, but the image >>> (a flashlight, or up in Scotland, a torch) carrying that script breaks up >>> on the screen, i.e. the image breaks up into two separate parts. Odd. >>> >> I tested your stack Jim. It was very interesting a

Re: Any thoughts on speed limitations of Revlet?

st.rev"; Not only does the "mouseMove" handler run lethargically, but the image (a flashlight, or up in Scotland, a torch) carrying that script breaks up on the screen, i.e. the image breaks up into two separate parts. Odd. I tested your stack Jim. It was very interesting

Re: Any thoughts on speed limitations of Revlet?

RainbowTest.rev"; > > Not only does the "mouseMove" handler run lethargically, but the image (a > flashlight, or up in Scotland, a torch) carrying that script breaks up on > the screen, i.e. the image breaks up into two separate parts. Odd. > I tested your stack

Any thoughts on speed limitations of Revlet?

Before I begin to dream about the potential of Revlet, I would like to have some idea about the potential, particularly the speed in running graphics. Just for fun I ran a small part of a stack meant to demonstrate the physics behind the rainbow. The stack, as a Revlet in Safari, is

Re: On-Rev founders - some speed data?

Don't you just love Forums :( 2009/4/24 Jim Lyons > On Apr 24, 2009, at 6:59 AM, David Bovill wrote: > > NB - AFAIK there is >> no mention of python on On-Rev - but I've not tested to see if it is >> installed - can;t imagine it won't be. >> > > There is a note in the on-rev forum that Python w

Re: On-Rev founders - some speed data?

On Apr 24, 2009, at 6:59 AM, David Bovill wrote: NB - AFAIK there is no mention of python on On-Rev - but I've not tested to see if it is installed - can;t imagine it won't be. There is a note in the on-rev forum that Python will/has been installed. Jim ___

Re: On-Rev founders - some speed data?

2009/4/24 Ben Rubinstein > Of course there are also odd things that are very slow > (you can crop an image faster in Transcript than using the built-in > command, > whch could perhaps be taken as a tribute to the speed of all the commands > other than 'crop') :) Do yo

On-Rev founders - some speed data?

On-Rev founders are in a unique position at this point to give some indication of the performance of the new facility (granting of course that there may be also sorts of debugging etc going on, or at least further optimisations possible in the future). I don't think that speed is going to b

Re: Rinaldi and Rev Speed wuz Re: Newbie

Totally right, Ray, got them switched. I heard John Nairn was a gardener by day and wrote that XCMD by night. True; one minor correct, though... Tom Pittman was the author of Compile-It, while John Nairn was the author of PrintReport (IIRC). Boy, that brings back memories... :-) Ken Ray

Re: Rinaldi and Rev Speed wuz Re: Newbie

... and Leonard Buck > Windowscript... > :-) René from Paris Le 7 déc. 08 à 08:57, Ken Ray a écrit : The speed thing is really true with Rev. When I started experimenting with Rev in late 2001 on Mac OS9, I wasted a whole lot of time worrying if my old XCMDs would run in the environm

Re: Rinaldi and Rev Speed wuz Re: Newbie

> The speed thing is really true with Rev. When I started experimenting > with Rev in late 2001 on Mac OS9, I wasted a whole lot of time > worrying if my old XCMDs would run in the environment. I was just > familiar with the way I always did it -- HC for the front end, XCMDs >

Rinaldi and Rev Speed wuz Re: Newbie

The speed thing is really true with Rev. When I started experimenting with Rev in late 2001 on Mac OS9, I wasted a whole lot of time worrying if my old XCMDs would run in the environment. I was just familiar with the way I always did it -- HC for the front end, XCMDs to do the heavy lifting

Re: Speed problems when cloning a group lots of times

On 7 Jul 2008, at 14:29, Trevor DeVore wrote: On Jul 7, 2008, at 9:21 AM, Ian Wood wrote: I figured the easiest way to do this would be to copy a group containing one lines-worth of controls and then paste it lots of times. Unfortunately the amount of time it takes to paste is increasing

Re: Speed problems when cloning a group lots of times

On Jul 7, 2008, at 9:21 AM, Ian Wood wrote: I figured the easiest way to do this would be to copy a group containing one lines-worth of controls and then paste it lots of times. Unfortunately the amount of time it takes to paste is increasing as the repeat loop goes on, AND Rev is then unre

Speed problems when cloning a group lots of times

arger (300+) numbers of lines. 100 lines = 800ms plus 1s freeze 200 lines = 3s plus 3s freeze 400 lines = 10s plus 19s freeze In a standalone, speed increases to about 1 millisecond per line and the unresponsiveness goes, but go above ~500 lines and it suddenly starts slowing down again:

Re: FrontScripts speed

ld run MUCH slower than the same script run from a stack script placed in the message path with "Start using"? Execution speed is pretty much unaffected by the location of the handler in the message path, with the only exception being a very minor (barely measurable) increase in

Re: FrontScripts speed

Tim Bleiler wrote: Anyone have any ideas why a script inserted into the front would run MUCH slower than the same script run from a stack script placed in the message path with "Start using"? Execution speed is pretty much unaffected by the location of the handler in the message

FrontScripts speed

Hi, Anyone have any ideas why a script inserted into the front would run MUCH slower than the same script run from a stack script placed in the message path with "Start using"? Thanks, Tim Bleiler University at Buffalo ___ use-revolution mailing

cgi load & access speed

This may not have any consequence at all, but it's hard to test, so I wanted an opinion or two. My cgi Rev stack (I'm using only one) has "ballooned" up to about 350k... certainly not large, but I could reduce it to 100k or so by moving a number of fields (which contain html formatting data

Re: Massive Speed difference between Mac/PC with SQLite

is is single command. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mai

Re: Massive Speed difference between Mac/PC with SQLite

Hi Dave, try building your database in :memory: mode. Then dump it to hard disk when ready. I do this routinely in an Rev/SQLite program that deals with 100 000 records distributed over 25 tables with about and 127 fields and it takes less then 2 seconds to copy the entire database to RAM and

Re: Massive Speed difference between Mac/PC with SQLite

Hi Dave try this: http://support.microsoft.com/?kbid=259716 For a full read of similar issues, here's another usefull link: http://bugs.mysql.com/bug.php?id=17984 Regards, -=- Xavier Bury Clearstream Services TNS NT LAN Server [EMAIL PROTECTED] wrote on

Re: Massive Speed difference between Mac/PC with SQLite

olution. Btw, just for your info: Valentina is able add into table with 17-19 fields 100,000 records in about 2.5-3 seconds (in best time). -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.para

Massive Speed difference between Mac/PC with SQLite

Hi, I have an application that works on Mac and PC. There is a process that read an XML file, re-arranges the data and writes a record to an SQLite database. On the Mac, to build a 10,000 Tracks database takes around 90 seconds, how ever on the PC the same code (both in the Standalone and

Re: A Small Speed Observation on Custom Properties

On Aug 22, 2007, at 10:00 AM, [EMAIL PROTECTED] wrote: If you guys are interested, I wrote code to build splitters for table fields, and I'm interested to hear what other people might think Yep, I'm interested. Send it along! Jim Lambert ___ use

Re: A Small Speed Observation on Custom Properties

If you guys are interested, I wrote code to build splitters for table fields, and I'm interested to hear what other people might think about it, and how to improve it. The code a) sets the tabstops so that the column widths adjust to the size of the data b) allows dragging of column lines to resiz

Re: A Small Speed Observation on Custom Properties

ther than calling the custom properties themselves within the loop. The second part of the handler below runs about ten times faster than the first for a field with 100 lines. And the speed is not affected by the fact that I initialized the variables using "add" instead of &quo

A Small Speed Observation on Custom Properties

you put the values of the custom properties into variables outside the loop and use the variables in the loop rather than calling the custom properties themselves within the loop. The second part of the handler below runs about ten times faster than the first for a field with 100 lines. And

Re: paintcompression and speed

Thanks Wilhelm! Viktoras ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution

Re: paintcompression and speed

An addendum to my first response: viktoras didziulis viktoras at ekoinf.net had written: > Any pointers on how paintCompression works... Dictionary says: "When an > image is changed with a paint tool, it is recompressed the next time you > leave the card it's on". The docs are wrong here:

Re: paintCompression and speed

On Sat Jul 21, 2007, viktoras didziulis viktoras at ekoinf.net wrote: http://www.sanke.org/Software/TestStackPaintcompression.zip>. Handling imagedata can be up to 12 times slower with paintcompression set to PNG than to RLE. Regards, Wilhelm Sanke -- Wilhelm

Re: paintCompression and speed

irectly updated - i.e. image gets compressed next time I leave the card it is on, isn't it? Or is image recompressed each time its imageData gets updated ? If so, likely RLE is the fastest method to choose or is it possible to disable paintCompression for images to get more speed for image update

paintCompression and speed

t is on, isn't it? Or is image recompressed each time its imageData gets updated ? If so, likely RLE is the fastest method to choose or is it possible to disable paintCompression for images to get more speed for image updates or RLE is the only option to go ? Or if imageData and not the

Re: Need for Speed: Arrays

guess the speed gain is once again modest. Does this mean that Rev is really efficient, almost irrespective of the strategy used in the program? Rev is extremely efficient and even the slow stuff is usually pretty fast. In this case it doesn't seem to matter, but there are other times

Need for Speed: Arrays

Dick Kriesel not only suggested trying arrays but wrote some code to test this. The least I could do was try it. Hit a bug on first pass, but Dick, the filtering (searching) section took 248seconds, or 4min 13 sec. So, I guess the speed gain is once again modest. Does this mean that Rev is

Re: Need for Speed ppps

opens it. But that's a very minor thing and doesn't interfere with the speed issue at all. I'm curious to know if Dick's array solution is any faster, if you get a chance to try it. His stuff is always genius. ON mouseUp ask file "Save as..." put it

  1   2   3   4   5   6   >