On Wednesday 07 Mar 2007, Dave Watts wrote:
I second the Who the hell needs that many files open at one time?
Unfortunately, that's just the way Foxpro works.
And it's supported on Vista, is it ?
A quick look at http://msdn2.microsoft.com/en-us/vfoxpro/bb190292.aspx
suggests not.
--
Tom
Dave,
She says, YOU DA MAN. Your solution worked perfectly. :)
Thanks much dude,
Will
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Thanks much dude
You're welcome!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit
My friend is having a problem with Vista giving her this error message:
Too many files open
She said she used to edit the config.nt file to say files=100 to fix it. But
that's not working here. She has between 40-100 files open in FoxPro 2.6.
Anyone have any ideas/suggestions?
Thanks much,
Subject: OT: Vista - too many files open error message- Dave watts?
My friend is having a problem with Vista giving her this error message:
Too many files open
She said she used to edit the config.nt file to say files=100 to fix it. But
that's not working here. She has between 40-100 files open
Open fewer files? Is there ever really a reason to have that many files
open?
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2007 8:26 AM
To: CF-Talk
Subject: OT: Vista - too many files open error message- Dave watts?
My friend is having
She needs more RAM if she wants to access that many files at once...
especially since Vista lays an egg if it *assumes* something *might* be
*potentially* wrong.
She says she's got 2gb ram and that shouldn't be an issue. I don't know enough
to know. Just trying to get pointed in the right
... =]
Cheers,
!k
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2007 8:46 AM
To: CF-Talk
Subject: Re: Vista - too many files open error message- Dave watts?
She needs more RAM if she wants to access that many files at once...
especially since
On Wednesday 07 Mar 2007, Andy Matthews wrote:
Open fewer files? Is there ever really a reason to have that many files
open?
Maybe it's a limit built into the particular type of Vista she has ?
--
Tom Chiverton
Helping to completely maintain total materials
On:
from ditching FoxPro, the suggestion to edit config.nt should still
work under Vista. Is she not able to edit it because editing it requires
administrative rights?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
Thanks Dave. I'm gonna get some more info from her.
Will
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/
Archive:
Dave,
She says this:
the first time i attempted to edit the file, vista yelled at me and said the
file was read only and would not let me save it. more than one way to skin a
catmade a new file, saved it as config1.nt, deleted config.nt after some
trouble-it finally let me delete (i
Maybe Vista replaces her changed file with the original on reboot?
I've seen that behavior before in Windows.
On 3/7/07, Will Tomlinson [EMAIL PROTECTED] wrote:
Dave,
She says this:
the first time i attempted to edit the file, vista yelled at me and said the
file was read only and would
I second the Who the hell needs that many files open at one time?
On 3/7/07, Jacob Munson [EMAIL PROTECTED] wrote:
Maybe Vista replaces her changed file with the original on reboot?
I've seen that behavior before in Windows.
On 3/7/07, Will Tomlinson [EMAIL PROTECTED] wrote:
Dave,
She
I second the Who the hell needs that many files open at one time?
Unfortunately, that's just the way Foxpro works.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC
as administrator, using the run as
administrator option. She should then be able to directly change the file
attributes (if it's read-only), edit and save the file.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction
on their temples the next day.
Emmet
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 1:06 AM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
lol, not hard to imagine why..
~Dave the disruptor~
Some people just don't appreciate how
Who cares, Troll?
--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or
Yea, public drunkeness is sooo last year people finding you naked
in the internet is this years fad ;)
After my clients find that out, they usually up what they are paying ;)
On 21/10/05, Scott Stroz [EMAIL PROTECTED] wrote:
If you start judging CF developers based on public drunkenness,
That's right, in fact I'm thinking about getting drunk RIGHT THIS MINUTE!!!
--Ferg
Scott Stroz wrote:
If you start judging CF developers based on public drunkenness, you will
have only a handful you will 'respect', and I am sure they will be helpful
after graduating from Middle School..
--
05:05
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
Actually I heard it first hand from the guy who had to drag him up to
his room. I was there, you were not. I also don't see how public
drunkeness is so great. What a waste
I was drunk when I got to work today. :) And it's Friday, which means
BEERS AT LUNCH! Woo-hoo!
Ken Ferguson wrote:
That's right, in fact I'm thinking about getting drunk RIGHT THIS MINUTE!!!
--Ferg
Scott Stroz wrote:
If you start judging CF developers based on public drunkenness,
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
lol, not hard to imagine why..
~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time.
From: Nathan Strutz [EMAIL
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 10:30 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
Private lives, drinking and the like are all fodder for the
CF-Community list and I'd appreciate this thread being moved there.
Thanks
[INFO
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
extremely poor taste and shows a lack of professionalism. Who else had to be
So Dave got drunk, started dancing, knocked his head on the bar, passed out
and then was drug to his hotel room? Man, you know if he had a blog all of
this could have been put there and avoided the need for all these emails :/
On 10/21/05, JediHomer [EMAIL PROTECTED] wrote:
Yea, public
I'd like to thank everyone for showing their true colors, who's a
professional, who is not, and how once again you love to shoot the
messenger. Now I see why my fellow programmers are dumping CF and moving to
..NET. The CF community has turned into a visious slap fest that provides no
value.
End
You got a dream job mano :)
Tim
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 12:06 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
I was drunk when I got to work today. :) And it's Friday, which means
BEERS
To misquote Abe Lincoln, if Dave's a drinker, then I'd like to send
some of what he's drinking to my other developers.
Matt Osbun
On 10/21/05, Fred Urban [EMAIL PROTECTED] wrote:
I'd like to thank everyone for showing their true colors, who's a
professional, who is not, and how once again you
of professionalism.
Who else had to be
drug up to their room and put to bed? He's lost any
respect I might have had
for him.
That wasn't Dave. It was me trying out my new Dave Watts
halloween costume. Sorry Dave I had a couple beers and
forgot to eat.
Lee
-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 10:21 AM
To: CF-Talk
Subject: RE: When will Dave Watts finally blog?
Threads about IE and CSS, MSSQL questions, hosting providers, these
things are all indirectly related to CF
the boundaries of this
list.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 10:30 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
Private lives, drinking and the like are all fodder for the
CF-Community
I'd like to thank everyone for showing their true colors, who's a
professional, who is not, and how once again you love to shoot the
messenger. Now I see why my fellow programmers are dumping CF and moving to
.NET. The CF community has turned into a visious slap fest that provides no
value.
End
I'd like to sincerely invite you to follow your fellow programmers on
that migration as soon as humanly possible. You might do well to start
the journey by unsubscribing from this list.
--Ferg
Fred Urban wrote:
I'd like to thank everyone for showing their true colors, who's a
professional,
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 2:03 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
I'd like to thank everyone for showing their true colors, who's a
professional, who is not, and how once again you love
You'll get ass-prints on my new door!
(Sorry... couldn't resist a clear Futurama reference.)
Jim Davis
h...Fry living in Bender's apartment??
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell:
and in 2000 at Orlando some CF evangelist type, wonder who that is,
was seen doing kareoke!
DK
On 10/21/05, Emmet McGovern [EMAIL PROTECTED] wrote:
you mean which ones didn't. there was entirely too much alcohol that night.
larry
Subject: Re: When will Dave Watts finally blog?
ENOUGH!
cf-community
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 2:26 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
You'll get ass-prints on my new door!
(Sorry... couldn't resist a clear Futurama reference.)
Jim Davis
I'm just glad that no ones talking about my various past public intoxication
problems.
I mean, have you guys ever seen me at an event?
Tim
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 1:36 PM
To: CF-Talk
Subject: Re: When will Dave
Sh!t... I'm drunk right now.
!k
-Original Message-
From: Tim Heald [mailto:[EMAIL PROTECTED]
Sent: October 21, 2005 12:44 PM
To: CF-Talk
Subject: RE: When will Dave Watts finally blog?
I'm just glad that no ones talking about my various past public intoxication
problems.
I mean, have
are you serious?
really?
GO PROGRAM .NET!
please.
On 10/21/05, Fred Urban [EMAIL PROTECTED] wrote:
I'd like to thank everyone for showing their true colors, who's a
professional, who is not, and how once again you love to shoot the
messenger. Now I see why my fellow programmers are dumping
And I'd like to thank you for showing me EXACTLY who you are. This topic is
closed. What people do at a conference is NOT on topic for this list and in
most places is their own business. As for your 'fellow' programmers moving
from CF, they must be somewhere other than America where CF is on a
I'm just glad that no ones talking about my various past public intoxication
problems.
I mean, have you guys ever seen me at an event?
Tim
you mean I can't post the videos?
larry
~|
Logware (www.logware.us): a new and
BOO YAH
see the door friend.
find yourself in it.
On 10/21/05, Michael Dinowitz [EMAIL PROTECTED] wrote:
And I'd like to thank you for showing me EXACTLY who you are. This topic is
closed. What people do at a conference is NOT on topic for this list and in
most places is
The one with the midget... yes. The donkey... no.
!K
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: October 21, 2005 2:00 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
I'm just glad that no ones talking about my various past public
intoxication
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this week.
On 10/11/05, Emmet McGovern [EMAIL PROTECTED] wrote:
I was reading Ray Camdens last post on his blog today and it really does
emphasize the lack of CF administration information out
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this week.
Lots of people got drunk at MAX. Lots of people get drunk at every
conference. Ever been to any conferences Fred?
--
Sean A Corfield --
Fred - First, Dave's one of the most known authorities around here.
Second, if someone _doesn't_ get fairly drunk at MAX, that's worth
noting.
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this
programmers drink beer?
you are f*ckin kidding me.
im sooo let down
/me runs
On 10/20/05, Sean Corfield [EMAIL PROTECTED] wrote:
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this week.
Fred Urban wrote:
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this week.
since when are people's private lives fodder for discussion on a list
devoted to cf?
~|
Logware
If anyone at MAX deserved a damn good drink it's the man himself.
On 10/20/05, Paul Hastings [EMAIL PROTECTED] wrote:
Fred Urban wrote:
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this week.
since when are people's private lives fodder
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
extremely poor taste and shows a lack of professionalism. Who else had to be
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
extremely poor taste and shows a lack of professionalism. Who else had to be
Yea Dave!
*boo fred*
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
extremely poor taste and
Fred Urban wrote:
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
extremely poor taste and shows a lack of professionalism.
Fred Urban wrote:
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference. Sure, everyone has a few beers,
lets their hair down, but to pass out drunk in a hotel lobby bar is in
extremely poor taste and shows a lack of
.
From: Jerry Johnson [EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 11:07 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: When will Dave Watts finally blog?
Yea Dave!
*boo fred*
On 10/20/05, Fred Urban wrote:
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
If you start judging CF developers based on public drunkenness, you will
have only a handful you will 'respect', and I am sure they will be helpful
after graduating from Middle School..
--
Scott Stroz
Boyzoid.com http://Boyzoid.com
___
Some days you are the dog,
Some days
-Original Message-
From: Fred Urban [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 10:50 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And I
thought MAX was a professional conference
:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 10:50 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
Dave was not drunk in private, Dave was passed out drunk IN PUBLIC. And
I
thought MAX was a professional conference. Sure, everyone has a few
beers,
lets their hair
On 10/20/05, Fred Urban [EMAIL PROTECTED] wrote:
Actually I heard it first hand from the guy who had to drag him up to his
room. I was there, you were not. I also don't see how public drunkeness is
so great. What a waste of brain cells.
So it's still hearsay then? And who cares? Clearly
: Friday, October 21, 2005 12:06 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: When will Dave Watts finally blog?
On 10/20/05, Fred Urban wrote:
Actually I heard it first hand from the guy who had to drag him up to his
room. I was there, you were not. I also don't see how public drunkeness
votekick
Oh sorry, wrong game.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free
Private lives, drinking and the like are all fodder for the CF-Community list
and I'd appreciate this thread being moved there.
Thanks
Fred Urban wrote:
I don't think Dave can stop drinking long enough to blog. I hear he got
extremely drunk at MAX this week.
since when are people's private
Funny you should say this. He just got booted from the phoenix cfug
list today...
-nathan strutz
http://www.dopefly.com/
On 10/20/05, dave [EMAIL PROTECTED] wrote:
$100 says this tard is connie, i heard she was trying to make a come
back
~Dave the disruptor~
Some people just don't
-Original Message-
From: Fred Urban [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 11:54 PM
To: CF-Talk
Subject: Re: When will Dave Watts finally blog?
Actually I heard it first hand from the guy who had to drag him up to his
room. I was there, you were not. I also
-talk@houseoffusion.com
Subject: Re: When will Dave Watts finally blog?
Funny you should say this. He just got booted from the phoenix cfug
list today...
-nathan strutz
http://www.dopefly.com/
On 10/20/05, dave wrote:
$100 says this tard is connie, i heard she was trying to make a come
back
I was reading Ray Camdens last post on his blog today and it really does
emphasize the lack of CF administration information out there. I know there
are other great blogs on the subject like Talking Tree and Brandon Purcell
but when will Dave finally shed some regular light on the subject?
How
Well though I'd definitely frequent a blog from Dave, I can hardly blame him
considering the number of things Figleaf is involved with.
!k
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: October 12, 2005 9:53 AM
To: CF-Talk
Subject: Re: When will Dave Watts finally
I was reading Ray Camdens last post on his blog today and it really does
emphasize the lack of CF administration information out there. I know there
are other great blogs on the subject like Talking Tree and Brandon Purcell
but when will Dave finally shed some regular light on the subject?
How
I use VMware Workstation 4 (http://www.vmware.com/); Microsoft bought
Virtual PC from Connectix, and will soon release several products based on
that (server and workstation).
The Virtual PC Workstation product has been released. Installing and setting up virtual machines is quite a bit slower,
I use VMware Workstation 4 (http://www.vmware.com/); Microsoft bought
Virtual PC from Connectix, and will soon release several products based on
that (server and workstation).
The Virtual PC Workstation product has been released. Installing and
setting up virtual machines is quite a bit slower,
Hey All (and Dave),
I know Dave and others have mentioned some software that they use for
cross-browser and I think even cross-OS testing.I've Googled it and can't
find it in the CF-Talk archives.
Anybody? or any other options?
TIA
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce
Hi Bryan:
I'm pretty sure you're looking for this...
VMWARE WORKSTATION 4
http://www.vmware.com/landing/ws4_home.html
I use this all the time... its a great tool.
Also, Microsoft has a similar product under development but I beleive it will be primarily targetted at the server market.
Regards,
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: David K
To: CF-Talk
Sent: Thursday, May 20, 2004 3:20 PM
Subject: Re: Attn: Dave Watts - cross browser testing
from Connectix, and will soon release several products based on
that (server and workstation).
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Check it out...
http://webtechniques.com/archives/2001/09/infrrevu/
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
I've heard Dave Watts has been kidnapped by aliens. Anyone know if this is
true?
jon
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf
do think that Java is the "language of the future", in that I think it'll
replace the use of C++ for general line-of-business application development.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202
Dave, you have mentioned a few times that you favor developing the front end in Cold
Fusion (and of course DHTML and Javascript), the back end in a SQL Database, and all
of the business logic in a middle layer.
Can you tell us more about what you use for that middle layer?
Do you write custom
probably wouldn't know, in most cases, and would just set it to 100. I
don't think that wasting space within the 32Kb buffer is very significant;
the bigger concern is avoiding the case where you specify too many rows to
fit within 32Kb.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com
ally it is." - Yoda
-Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 23, 2000 7:14 PM
To: CF-Talk
Cc: '[EMAIL PROTECTED]'
Subject: RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS
How large are buffers set to? I often use
BLOCK
an integer,
your maximum row size will be 4 bytes. One hundred rows of 4 bytes each will
take 400 bytes, which will be a small fraction of the maximum buffer size of
32,768 bytes.
In summary, don't worry about it!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax:
case, I'd generally regard an error as more serious than slower
performance.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book
Anyone else find it amusing that Dave Watts' signature includes a Fusebox
ad? Here's a sample:
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~
Structure your ColdFusion code
:07
To: CF-Talk
Subject: Extra: Dave Watts endorses Fusebox!
Anyone else find it amusing that Dave Watts' signature includes a Fusebox
ad? Here's a sample:
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
as someone to take the posts and write
summaries and a FAQ. Its a big job and hiring a professional to do it is the
best idea. Just a matter of time. :)
Anyone else find it amusing that Dave Watts' signature includes a Fusebox
ad? Here's a sample:
Dave Watts, CTO, Fig Leaf Softwar
On 11/21/00, Ben Forta penned:
CF will not generate an error if the database does not support block
factoring, it's far worse than that. CF has no way to poll the database to
see what it supports, so if you specify a number to high it'll try that, if
that fails it'll try a lesser number, and then
(and takes memory away from where
it could be more efficiently used).
Well, how can you know when it's needed? Obviously, when doing a
search, you may return 1,000 records, or you may return 1.
You won't be able to exactly determine the optimal value for each use.
You'll have to estimate.
Dave
able to answer my other question about if or not the MAXROWS
would take precedence and if a stored procedure was used, what effect
BLOCKFACTOR and MAXROWS have if the SP itself was limiting rows.
Thanks a bunch,
James
- Original Message -
From: "Dave Watts" [EMAIL PROTECTE
On 11/21/00, J.Milks penned:
BLOCKFACTOR
Optional. Specifies the maximum number of rows to fetch at a time from the
server. The range is 1 (default) to 100. This parameter applies to ORACLE
native database drivers and to ODBC drivers. Certain ODBC drivers may
dynamically reduce the block factor
, determines how many records CF will accept from
the database; if you only want to show ten records, you'd set MAXROWS to 10.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion
ecause you might not get optimal performance
otherwise. I could be wrong about this, though. I don't know enough about
how things work at that relatively low level to be sure one way or the
other.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202
: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 2:13 PM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS
I started this thread, and its evolution has lead me to
believe that in fact I may not understand the implementation
On 11/21/00, Dave Watts penned:
I don't think you'd always want to simply set BLOCKFACTOR to 100. If you set
the BLOCKFACTOR too large, the database driver will lower it - and I'm not
sure exactly how it figures out what to lower it to. It might simply lower
it back to the default value of 1
And for the most efficiency, why not just always use BLOCKFACTOR=100 ?
Why is the default the most inefficient choice?
Is there any advantage in uses a lower number?
At 03:12 PM 11/21/00 -0500, Dave Watts wrote:
I started this thread, and its evolution has lead me to
believe that in fact I
Is BLOCKFACTOR=10 the same as a SQL Select top 10 *?
No, it's not. It has absolutely no effect on how many records are returned
from the database to CF. It only affects how they're returned.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
]
www.vividmedia.com
608.270.9770
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 2:13 PM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS
I started this thread, and its evolution has
1 - 100 of 117 matches
Mail list logo