Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-12-01 19:01, Charlie wrote: FYI, I did more research on this and just never sent in an update. The key point is whether or not the table was opened "EXCLUSIVE" or not. If you open it exclusive, there is a "chance" the memo "block" will be reused (if the new text size is the same or smaller than what was used before). But opening the table in shared mode means EVERY save to the memo will cause a NEW memo block to be appended to the .FPT file. I was going to write up some code folks could run to show this behavior, but didn't get to it. So the proof is left as a homework assignment. :) Well that would be intelligent design when in exclusive mode if true. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/6c0ff1a2160b802d83311f86d74a8...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 11/30/2016 5:40 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: One thing I put into my design is working with temporary cursors or As I recall, the main reason for memo bloat was caused when saving data. Specifically, if I was editing a memo, then saved it, if the Just an update: found 2 records that had bazillions lines in them (determined via MEMLINES), and the process was continually adding another line every 6 minutes since August 2016. No wonder the file size spiraled. Problem source fixed from vendor side. All good now. FYI, I did more research on this and just never sent in an update. The key point is whether or not the table was opened "EXCLUSIVE" or not. If you open it exclusive, there is a "chance" the memo "block" will be reused (if the new text size is the same or smaller than what was used before). But opening the table in shared mode means EVERY save to the memo will cause a NEW memo block to be appended to the .FPT file. I was going to write up some code folks could run to show this behavior, but didn't get to it. So the proof is left as a homework assignment. :) -Charlie ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/22e8e73c-8ccf-7d98-38b4-12596c5c9...@verizon.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-11-03 17:31, Charlie wrote: On 11/3/2016 2:24 PM, Gene Wirchenko wrote: [snip] I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? One thing I put into my design is working with temporary cursors or objects (aka from SCATTER MEMO NAME oDataRec). I rarely have user interface objects directly accessing DBFs. As I recall, the main reason for memo bloat was caused when saving data. Specifically, if I was editing a memo, then saved it, if the contents were larger than my "blocksize", VFP would create a whole new "block" in the .fpt file. The original block is essentially wasted space at that point. I think there are some nuances to this: e.g. VFP doesn't see it as "bigger" unless the "blocksize" threshold is crossed - or maybe the text has to be "bigger" than the text 1st edited. I can't remember. Just an update: found 2 records that had bazillions lines in them (determined via MEMLINES), and the process was continually adding another line every 6 minutes since August 2016. No wonder the file size spiraled. Problem source fixed from vendor side. All good now. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f7eb16247dd20a60d568fba87d52c...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
At 14:06 2016-11-03, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2016-11-03 14:24, Gene Wirchenko wrote: I have a routine that packs and reindexes all of the tables. I have not needed anything more involved. I do see some memo bloat. I have a table that stores configuration data. When packed, the .fpt is 1280 bytes. I see from the latest sent to me that it is up to 5,205,248 bytes. That is bigger than the source code. Would the PACK do a reindex automatically? According to VFP Help (also here: https://msdn.microsoft.com/en-us/subscriptions/downloads/t2704cs4(v=vs.80).aspx ): "If the current table has one or more indexes open, PACK rebuilds the index files." So your reindex, Gene, must be the EXPLICIT kind of reindex akin to Stonefield Database Toolkit or your own explicit INDEX Field TAG MyOrder commands. Otherwise, if you're just doing REINDEX, sounds to me like you're doing it twice. In fact, if you're running your own reindex, you may as well do a DELETE TAG ALL beforehand to avoid the double-work. I do not use reindex. I decided to check. I found that I do the table pack before I call the table's indexing routine. The indexing routines all had delete tag all, but that is too late. I have added one to just before the pack. I had not caught this since my indexing runs fairly quickly. Thank you. Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f357a17db8fb186f0038f0bf43c0075f@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
At 12:06 2016-11-03, Ted Roche wrote: On Thu, Nov 3, 2016 at 2:10 PM, Gene Wirchenko wrote: > > As possibly the last to answer -- is there a prize? -- let me state > DBFs. Mostly just stirring the pot. There's a wealth of knowledge here. DBFs: 13 MS SQL Server: 8 1 each for everything else: Azure, Excel, XML, SQLite, PostgreSQL, JSON, Oracle, My/MariaDB Stirring the pot? Is that like some cannibals believe they absorb the abilities of those they eat? (It is only four days after Hallowe'en.) I would be interested in why each person has gone his particular way. For me, we do not need anything else really. It would be a lot of disruption and complication for little or no benefit. Sincerely, Gene Wirchenko -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1364bf98833629e5e6c0b205001a471f@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
We currently have an fpt file that has reached 250 mb, When I need to add another memo field, I create a dbf with only the key and the memo field and relate it to the other database. This way each memo can grow up to 2 GB in size I do a pack memo once a week and save a copy of the pre-packed dbf and fpt just in case. Archiving old data or splitting memos among multiple databases is the way to fix the problem . I don't feel safe when a memo file goes over 1 GB. It's probably best to have some sort of warning built into your software that tells you when it's close to 2.GB so you can make adjustments. Once it goes over 2 GB, things get scrambled and may not open at all. I have had minor corruption over the years, but nothing major that I couldn't fix from a backup. Of course, make sure you backup every night. From: "mbsoftwaresoluti...@mbsoftwaresolutions.com" To: ProFox Email List Sent: Thursday, November 3, 2016 11:14 PM Subject: Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch)) On 2016-11-03 19:25, Richard Quilhot wrote: > Divide the data into smaller DBF's then add code the select the correct > small table that needs updating. Not an option at this point. Besides...this table has only ONE memo field. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/112564499.109533.1478261103...@mail.yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-11-03 19:25, Richard Quilhot wrote: Divide the data into smaller DBF's then add code the select the correct small table that needs updating. Not an option at this point. Besides...this table has only ONE memo field. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/076c4e2d68bc4f0d7df489e9e0e7d...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
Divide the data into smaller DBF's then add code the select the correct small table that needs updating. Rick Q quilh...@gmail.com On Thu, Nov 3, 2016 at 2:24 PM, Gene Wirchenko wrote: > At 08:56 2016-11-03, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > >> On 2016-10-28 10:24, Kevin J Cully wrote: >> X DBFs - I have a client that insisted I use DBFs for his desktop and >> Web-Connection site. It's run almost flawlessly since 2008 with the >> exception of the 'memo field bloat' issue. That's caught me a couple >> of times over the years hitting the 2G limit per file. >> > > I'm handling one of Jeff Johnson's (RIP) clients and having this issue. >> I was about to create a simple utility for the end-user to grab the table >> and pack it, but curious if you've got a better idea? >> > > I have a routine that packs and reindexes all of the tables. I have > not needed anything more involved. > > I do see some memo bloat. I have a table that stores configuration > data. When packed, the .fpt is 1280 bytes. I see from the latest sent to > me that it is up to 5,205,248 bytes. That is bigger than the source code. > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadazp2mpcygowdusgs3lcyair0+yoo5td+iprj6tedureh_...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-11-03 17:31, Charlie wrote: One thing I put into my design is working with temporary cursors or objects (aka from SCATTER MEMO NAME oDataRec). I rarely have user interface objects directly accessing DBFs. I did this years ago with my MBSS framework based upon your ideas when you presented as such as Central PA VFP Users Group back in what...1998? Been problem free ever since. Great approach. As I recall, the main reason for memo bloat was caused when saving data. Specifically, if I was editing a memo, then saved it, if the contents were larger than my "blocksize", VFP would create a whole new "block" in the .fpt file. The original block is essentially wasted space at that point. I think there are some nuances to this: e.g. VFP doesn't see it as "bigger" unless the "blocksize" threshold is crossed - or maybe the text has to be "bigger" than the text 1st edited. I can't remember. So, if you have a GUI screen element that is directly bound to the DBF memo field, every time you type a character (well, every few characters maybe), a new .fpt block gets assigned, wasting the previous one. So imagine if you have users typing quite a bit of text in there, editing, yada yada. One editing session might cause dozens of "blocks" in the memo file to be wasted. But if you take my approach, there is only 1 "write" operation (when data is saved) and therefore, at worst, 1 wasted .ftp "block". Take a look at "SET BLOCKSIZE". If you can't really change a bunch of source code, simply "recreating" a table with a different memo blocksize can sometimes solve the bloat problem. E.g. if the memo field will almost always have more than 100 characters, but rarely have over 512, do a SET BLOCKSIZE to 1. Once the table is created I think the blocksize for the memo fields are "locked in". And I don't think a simple MODIFY STRUCTURE will adjust to the new blocksize, so you may have to do some "table-create-swap" thing. The default is 64 bytes. And be advised, setting it to 1 thru 32 is not in bytes, it is in 512 byte chunks (SET BLOCKSIZE to 1 is 512, setting to 2 is 1024, ... up to 32). After 32, the number is interpreted as straight bytes. Of course, as always, test these things out, run some variations. I created this simple test, without regard for blocksize, on a copy of the table on my own machine last weekend: CLEAR SET ESCAPE ON LOCAL liCnt as Integer liCnt = 0 CLOSE DATABASES all USE c:\crap\vendor SHARED DO WHILE .T. liCnt = liCnt + 1 ? liCnt WAIT WINDOW NOWAIT "Iteration " + ALLTRIM(STR(liCnt)) UPDATE vendor SET ven_note = ven_note ENDDO It hit the 2GB limit after so many iterations. So I'm not sure the blocksize plays a part. This code below says average note length is just under 130 characters: SELECT LEN(ALLTRIM(ven_note)) as iLen FROM vendor INTO CURSOR MyLens SELECT AVG(iLen) FROM MyLens ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ba7b572ef12048b906d7e35301d32...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 11/3/2016 2:24 PM, Gene Wirchenko wrote: [snip] I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? One thing I put into my design is working with temporary cursors or objects (aka from SCATTER MEMO NAME oDataRec). I rarely have user interface objects directly accessing DBFs. As I recall, the main reason for memo bloat was caused when saving data. Specifically, if I was editing a memo, then saved it, if the contents were larger than my "blocksize", VFP would create a whole new "block" in the .fpt file. The original block is essentially wasted space at that point. I think there are some nuances to this: e.g. VFP doesn't see it as "bigger" unless the "blocksize" threshold is crossed - or maybe the text has to be "bigger" than the text 1st edited. I can't remember. So, if you have a GUI screen element that is directly bound to the DBF memo field, every time you type a character (well, every few characters maybe), a new .fpt block gets assigned, wasting the previous one. So imagine if you have users typing quite a bit of text in there, editing, yada yada. One editing session might cause dozens of "blocks" in the memo file to be wasted. But if you take my approach, there is only 1 "write" operation (when data is saved) and therefore, at worst, 1 wasted .ftp "block". Take a look at "SET BLOCKSIZE". If you can't really change a bunch of source code, simply "recreating" a table with a different memo blocksize can sometimes solve the bloat problem. E.g. if the memo field will almost always have more than 100 characters, but rarely have over 512, do a SET BLOCKSIZE to 1. Once the table is created I think the blocksize for the memo fields are "locked in". And I don't think a simple MODIFY STRUCTURE will adjust to the new blocksize, so you may have to do some "table-create-swap" thing. The default is 64 bytes. And be advised, setting it to 1 thru 32 is not in bytes, it is in 512 byte chunks (SET BLOCKSIZE to 1 is 512, setting to 2 is 1024, ... up to 32). After 32, the number is interpreted as straight bytes. Of course, as always, test these things out, run some variations. HTH, -Charlie [snip] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/036fab06-2c19-0bf0-76b5-9ff28c3a8...@verizon.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-11-03 14:24, Gene Wirchenko wrote: I have a routine that packs and reindexes all of the tables. I have not needed anything more involved. I do see some memo bloat. I have a table that stores configuration data. When packed, the .fpt is 1280 bytes. I see from the latest sent to me that it is up to 5,205,248 bytes. That is bigger than the source code. Would the PACK do a reindex automatically? According to VFP Help (also here: https://msdn.microsoft.com/en-us/subscriptions/downloads/t2704cs4(v=vs.80).aspx ): "If the current table has one or more indexes open, PACK rebuilds the index files." So your reindex, Gene, must be the EXPLICIT kind of reindex akin to Stonefield Database Toolkit or your own explicit INDEX Field TAG MyOrder commands. Otherwise, if you're just doing REINDEX, sounds to me like you're doing it twice. In fact, if you're running your own reindex, you may as well do a DELETE TAG ALL beforehand to avoid the double-work. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0239ac85aa726fbeeeb2cebb17c52...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On Thu, Nov 3, 2016 at 2:10 PM, Gene Wirchenko wrote: > > As possibly the last to answer -- is there a prize? -- let me state > DBFs. > Mostly just stirring the pot. There's a wealth of knowledge here. DBFs: 13 MS SQL Server: 8 1 each for everything else: Azure, Excel, XML, SQLite, PostgreSQL, JSON, Oracle, My/MariaDB -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4u-7jzbnojip5kbhz-cqfqncsoxknz3lwhmzeih+og...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
At 08:56 2016-11-03, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? I have a routine that packs and reindexes all of the tables. I have not needed anything more involved. I do see some memo bloat. I have a table that stores configuration data. When packed, the .fpt is 1280 bytes. I see from the latest sent to me that it is up to 5,205,248 bytes. That is bigger than the source code. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1324d2dfb2fc7e838a23ddb6f4fb7803@mtlp87 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
At 06:00 2016-10-28, Ted Roche wrote: So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) As possibly the last to answer -- is there a prize? -- let me state DBFs. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fe9732a74f94ecd75107ad91c1251879@mtlp87 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-11-03 12:14, Kevin J Cully wrote: I created a subclass of the wwMaint.prg and then put that behind an authentication. I then added various PACKing routines: Some pack all tables, others pack the "vulnerable to memo bloat" tables. The problem is getting exclusive access to the tables. If you're running in COM mode, then WWWC has a way of stopping all instances except one. If you're running in File mode which is what I'm doing, I have to remote in and kill the extra instances and then run the pack. It's a pain. Not sure how it's being run, but I would suspect File mode. Terminal Server is involved with this client, which I've not dealt with before, but not sure if that's important for the matter at hand. I've considered moving the table to PostgreSQL and not telling the client. Tempted but I haven't gone through with it. I hear ya. I was thinking "man, I don't have this problem with MySQL (MariaDB)" ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cc8411a987f812f31ad19416984a3...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
I created a subclass of the wwMaint.prg and then put that behind an authentication. I then added various PACKing routines: Some pack all tables, others pack the "vulnerable to memo bloat" tables. The problem is getting exclusive access to the tables. If you're running in COM mode, then WWWC has a way of stopping all instances except one. If you're running in File mode which is what I'm doing, I have to remote in and kill the extra instances and then run the pack. It's a pain. I've considered moving the table to PostgreSQL and not telling the client. Tempted but I haven't gone through with it. -Kevin -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursday, November 03, 2016 11:57 AM To: profox@leafe.com Subject: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch)) On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f82db4de49440845a14b540f6c2df6a91dc...@blufitspmbs01.cherokeega.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fb2684c7cd4a909e6a38cf87e487e...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e044193ba7018293428c650c963e0...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On 2016-10-28 10:59, Peter Cushing wrote: __ DBFs Yup - sooner or later we will look to move to SQL but we don't want to rush into things LOL! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5d0824c6bbada921f791df5b52a71...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On 2016-10-28 09:00, Ted Roche wrote: So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) My backend data of choice for MBSS has been MySQL, and then MariaDB since it forked off from MySQL. Corporate gig loves SQL Server, and I crafted a slick DBF app too. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/587052c3509f4507969802c7c1a65...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))
You may also consider creating another new account to test everything. Good luck! ;) On Sat, Oct 29, 2016 at 11:01 PM, Kurt @ VR-FX wrote: > Nope re/retent - newly sent also don't show up. > Am sure acct settings R fine - but will Chk tonight! > Thx, -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mjaiufh17tz+hz01lu7wz+ckttdf_oa_0msnbdbwp6o...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))
Nope re/retent - newly sent also don't show up. Am sure acct settings R fine - but will Chk tonight! Thx, -K- Sent from my iPhone > On Oct 29, 2016, at 10:01 AM, Man-wai Chang wrote: > > Were those messages marked expired and got deleted automatically? > Check account and server settings (Retention Policy)! > > Or were they saved in a different Sent folder? Again, check account > and server settings. > >> On Sat, Oct 29, 2016 at 1:08 AM, Kurt Wendt wrote: >> Hate to pull this TOO Far off topic. But, since SQLite was brought up. >> Wasn't it mentioned here that it was used as the data for Mozilla >> Thunderbird - the e-mail reader? I'm still having a problem in Thunderbird - >> but only on my laptop - where NO Emails show up in the Sent folder. I even >> did some research on Google - but, could not seem to find a real answer to >> my problem. > > -- > .~. Might, Courage, Vision. SINCERITY! > / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) > /( _ )\ http://sites.google.com/site/changmw > ^ ^ May the Force and farces be with you! > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0f0dcdc4-a5de-4a75-9dcd-152b4562e...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))
Were those messages marked expired and got deleted automatically? Check account and server settings (Retention Policy)! Or were they saved in a different Sent folder? Again, check account and server settings. On Sat, Oct 29, 2016 at 1:08 AM, Kurt Wendt wrote: > Hate to pull this TOO Far off topic. But, since SQLite was brought up. Wasn't > it mentioned here that it was used as the data for Mozilla Thunderbird - the > e-mail reader? I'm still having a problem in Thunderbird - but only on my > laptop - where NO Emails show up in the Sent folder. I even did some research > on Google - but, could not seem to find a real answer to my problem. > -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mja-rtso5nzubf1p5yb4gnveq2we3z_hkjdyvpfkncf...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))
Hate to pull this TOO Far off topic. But, since SQLite was brought up. Wasn't it mentioned here that it was used as the data for Mozilla Thunderbird - the e-mail reader? I'm still having a problem in Thunderbird - but only on my laptop - where NO Emails show up in the Sent folder. I even did some research on Google - but, could not seem to find a real answer to my problem. Regards, Kurt Wendt Senior Systems Analyst Tel. +1-212-747-9100 www.GlobeTax.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Vince Teachout Sent: Friday, October 28, 2016 12:50 PM To: profoxt...@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch) On 10/28/2016 9:54 AM, Dave Crozier wrote: > M$SQL 2012 > VFP Databases > SQLite How do you like SQLite, Dave? I've downloaded it and planning to start playing with it so I can start Android programming. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f2f9...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On 10/28/2016 9:54 AM, Dave Crozier wrote: M$SQL 2012 VFP Databases SQLite How do you like SQLite, Dave? I've downloaded it and planning to start playing with it so I can start Android programming. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/9db482bf-fc41-a089-9e51-82ff7d792...@taconic.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
>> I don't see SQLite mentioned much. > Single user and insecure so that kind of limits real-world usage to phone applications and similar local storage use cases, as far as I can see. You wouldn't be putting a big production database on it. The following from the SQLite email list. Sent from the CEO of Expensify. Love SQLite? Wish you could use it to power your enterprise SaaS or web service? Now you can! Check out Expensify Bedrock, our distributed transaction layer built atop SQLite, powering Expensify's millions of users. More information is here: http://bedrockdb.com Keep all the power and simplicity of SQLite, but wrapped in a package that provides network accessibility, WAN-optimized replication, and distributed ACID transactions. Under continuous development and operation for the past 8 years, now it's open sourced and ready for your production use. Thank you to the SQLite team for not only producing such an incredible database, but helping with our countless questions and demanding requirements. I'm ecstatic to share this with you, and I hope you enjoy it too! Malcolm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1477673339.1728310.770455089.2d645...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On 10/28/2016 9:00 AM, Ted Roche wrote: So, where's your data stored today? MS Sql, followed by DBF ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/61b4eddd-c770-4e41-34bf-1835283d5...@taconic.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On Fri, 28 Oct 2016, at 04:20 PM, Ted Roche wrote: > I don't see SQLite mentioned much. Single user and insecure so that kind of limits real-world usage to phone applications and similar local storage use cases, as far as I can see. You wouldn't be putting a big production database on it. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1477672780.1098966.770444001.4d902...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
Rush??? I suspect, however, you meant that kind of 'tongue in cheek'. Regards, Kurt Wendt Senior Systems Analyst Tel. +1-212-747-9100 www.GlobeTax.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Friday, October 28, 2016 11:00 AM To: profoxt...@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch) On 28/10/2016 14:00, Ted Roche wrote: > So, where's your data stored today? > > __ DBFs Yup - sooner or later we will look to move to SQL but we don't want to rush into things Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f2f9...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
X_ MS SQL Server In fact - I just completed a 4-day class last week at the Learning Tree on M$ SQL. It was kinda Nuts - as they jammed TOO Much into a 4-day class - would have been better to be 5 or 6 days! And, some of you may find it peculiar - since I've been working this job for 1.5 years now and working w/M$ SQL on the job ever since starting here. That being said - I did learn a LOT of new things in the class - so it was indeed worthwhile. Regards, Kurt Wendt Senior Systems Analyst Tel. +1-212-747-9100 www.GlobeTax.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profoxt...@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f2f9...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
Ted, We use it to interface onto the Android tablets as it is obviously Android Native. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 28 October 2016 16:20 To: profox@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch) On Fri, Oct 28, 2016 at 9:54 AM, Dave Crozier wrote: > M$SQL 2012 > VFP Databases > SQLite > > Dave > I don't see SQLite mentioned much. I've worked with it in a couple of situations (including a book by Whil Hentzen I edited) but haven't used it in a production system. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2a4375...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
__ DBFs 80% clients __ MS SQL Server 20% clients Jose Enrique Llopis www.multilinkcrm.com -Mensaje original- De: ProFox [mailto:profox-boun...@leafe.com] En nombre de Ted Roche Enviado el: viernes, 28 de octubre de 2016 15:01 Para: profox@leafe.com Asunto: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/B3B7F030BB7E49A1BD2A9E10568108A8@LENOVO1 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On Fri, Oct 28, 2016 at 9:54 AM, Dave Crozier wrote: > M$SQL 2012 > VFP Databases > SQLite > > Dave > I don't see SQLite mentioned much. I've worked with it in a couple of situations (including a book by Whil Hentzen I edited) but haven't used it in a production system. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4tO8PU6tjNzph_Jgoi0GiZUFTm=g0ojs4qsdpgmb0i...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On 28/10/2016 14:00, Ted Roche wrote: So, where's your data stored today? __ DBFs Yup - sooner or later we will look to move to SQL but we don't want to rush into things Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7b9f532d-098a-1e21-41a5-c416729f2...@whisperingsmith.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
On 10/28/2016 06:00 AM, Ted Roche wrote: So, where's your data stored today? X_ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e5a179e3-de49-2ea9-f417-78bc23520...@americansentry.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
In DBFs for work data and fixed reference values, and Oracle 11 for consolidated data. Fernando D. Bozzo 2016-10-28 16:24 GMT+02:00 Kevin J Cully : > X PostgreSQL - CULLYTechs system runs on PostgreSQL for years now without > a hiccup. Big fan. > > X DBFs - I have a client that insisted I use DBFs for his desktop and > Web-Connection site. It's run almost flawlessly since 2008 with the > exception of the 'memo field bloat' issue. That's caught me a couple of > times over the years hitting the 2G limit per file. > > X MS SQL Server - For my day job with the County Govt, they are a > Microsoft shop. Unfortunately. MSSQL is pretty good and stable, I must > admit. > > X JSON - When I save settings and other small infrequently saved items, > I've been saving them as individual JSON files per user. Xojo makes it easy > to load and save them and access them like a dictionary. > > Side note: every time I visit a news site in Firefox and the Flash > place-holder shows up where the flash media normally would have played, I > smile a bit inside I wasn't subjected to the auto-play media. > > -Kevin > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche > Sent: Friday, October 28, 2016 9:01 AM > To: profox@leafe.com > Subject: Friday Poll (while dl'ing MS Flash Patch) > > So, where's your data stored today? > > __ DBFs > > __ MS SQL Server > > __ Azure > > __ Postgres > > __ My/MariaDB > > __ Oracle > > __ Excel > > __ Other (please specify) > > > (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe > Flash. You likely want to patch NOW. After answering the poll, of course.) > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGQ_Juku2Ro6fdQOeATtYPsa=exmbkesmc+7xde3e5brgcb...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
X PostgreSQL - CULLYTechs system runs on PostgreSQL for years now without a hiccup. Big fan. X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. X MS SQL Server - For my day job with the County Govt, they are a Microsoft shop. Unfortunately. MSSQL is pretty good and stable, I must admit. X JSON - When I save settings and other small infrequently saved items, I've been saving them as individual JSON files per user. Xojo makes it easy to load and save them and access them like a dictionary. Side note: every time I visit a news site in Firefox and the Flash place-holder shows up where the flash media normally would have played, I smile a bit inside I wasn't subjected to the auto-play media. -Kevin -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f82db4de49440845a14b540f6c2df6a91db...@blufitspmbs01.cherokeega.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
DBFs MS Sql Server Ajit Abraham On 28-Oct-16 4:00 PM, Ted Roche wrote: So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fbe0d9b9-75e4-296e-71bf-c3cfb3649...@ua-group.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
DBFs - I'm old fashioned (and I don't have much data anymore) John Weller 07976 393631 01380 723235 Sent from my iPhone > On 28 Oct 2016, at 14:00, Ted Roche wrote: > > So, where's your data stored today? > > __ DBFs > > __ MS SQL Server > > __ Azure > > __ Postgres > > __ My/MariaDB > > __ Oracle > > __ Excel > > __ Other (please specify) > > > (P.S. Microsoft released an out-of-band (i.e., emergency) patch for > Adobe Flash. You likely want to patch NOW. After answering the poll, > of course.) > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/3247f458-da2f-4a6e-b77d-5a86c5f4c...@jbweller.force9.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
M$SQL 2012 VFP Databases SQLite Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 28 October 2016 14:01 To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2a4375...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Friday Poll (while dl'ing MS Flash Patch)
dbf --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/!&!AAAYAAZ6acx/WBlNqEIsKHz6tc0ClgAAEIRi8xEjFDJLtKIO0uhMvBEBAA==@bdos.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
__ Other (please specify) XML files for fitting data that NEVER changes. USA States and Countries are never changing data in my mind and something that is faster to pull off the website file instead of hitting the sql backend for it. I have plenty of others as well that fit our business/industry. Package type Plastic Type Customer type Carrier Type just as a short list. On Fri, Oct 28, 2016 at 8:00 AM, Ted Roche wrote: > So, where's your data stored today? > > __ DBFs > > __ MS SQL Server > > __ Azure > > __ Postgres > > __ My/MariaDB > > __ Oracle > > __ Excel > > __ Other (please specify) > > > (P.S. Microsoft released an out-of-band (i.e., emergency) patch for > Adobe Flash. You likely want to patch NOW. After answering the poll, > of course.) > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+yK9OhKzJ++T0g5PAOh5_TZf85HYf8A4qcR=dxn+d...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Friday Poll (while dl'ing MS Flash Patch)
DBFs MSSQL Azure (for testing and playing around) Excel (although I don't use it like a database, due to not being insane) -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1477660892.1054117.770238617.64486...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.