Re: Am I crazy?

From: Howard Minor (howard_at_medcomsolutions.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 16:17:02 -0400

Yes, that was one of my first solutions. I designed a pretty extensive
query screen to limit their searching to easily select a few dozen records
to ease the load. What do they do? They select all the departments so they
can retreive all the records in the database. They tell me they want to see
everything and made me remove the query screen.

Darn users...

Thanks. I just need to know it's not me.

-Howard

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:%23ktee3%23pEHA.556@TK2MSFTNGP11.phx.gbl...
> 15,000 rows is "crazy". You sound pretty sane to me...
> I expect your application design needs a bit of tuning to fetch fewer rows
> (a lot fewer). A strategy that fetches just what the customer needs (now)
> scales better.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Howard Minor" <howard@medcomsolutions.com> wrote in message
> news:%23Rduiu%23pEHA.3712@TK2MSFTNGP15.phx.gbl...
> > Here's my general setup:
> > VB6 application with SQL server approx 10 users.
> > ADO control bound to a datagrid.
> > Continual validation for several fields in the WillMove/MoveComplete
(this
> > usually involves a quick query to the database) including changing the
> > cell
> > color based on what they type etc...
> > Entire row can be locked depending on value of one of the fields.
> > Users can data enter in the grid but also in a seperate zoom form to
> > display
> > more/all fields. (Any changes in the zoom form must be sent back for
> > display in the grid).
> > Grid has features like sorting, CTRL-F function, some fields locked,
lots
> > of
> > bells and whistles...
> >
> > The problem is that there is a sporatic problem where data might get
> > shifted
> > or placed in the wrong field. Users can edit in a field that is
supposed
> > to
> > be locked. Navigation can be very slow and users can type while the
> > validation is catching up. Happens to someone about once a week.
> >
> > I can't replicate the errors and I just need to know if the following
> > reasons could be a factor:
> > Users pull in 7,000 to 15,000 records in the grid.
> > Our server is used for several applications and is used in very heavy
> > processing throughout the day.
> > Users can have several of these applications open at the same time.
> >
> >
> > Could the large recordsets combined with the slower server cause trouble
> > in
> > the bound controls? With the validation and dynamics in the movement of
> > the
> > ado control, could that theoretically affect the editable cursor in the
> > recordset if they navigate and type too fast? I told them it's not a
good
> > idea to do this with such a large recordset and so much validation. I
> > have
> > never replicated the problems on an isolated test machine.
> >
> > Am I crazy?
> >
> > Thanks,
> > Howard
> >
> >
> >
> >
> >
> > --
> > -----------------------------------------------
> > Howard Minor
> > Software Engineer
> > howard@medcomsolutions.com
> > 814.833.8481
> >
> >
>
>

Relevant Pages

  • Re: data scaling and validation for learning classifier
    ... My definitions of validation and testing are ... the standard in neural network design (See the ... Test = Current Nondesign + Future Nondesign ... your best design or fold your tent. ...
    (sci.stat.math)
  • CfP : Workshop on Model Design and Validation (MoDeVa) at Models
    ... Design and validation methods appear to be more and more necessary ... modular first order languages are suitable for this ... Robert France ...
    (comp.theory)
  • Re: Validate Two Date Fields
    ... Thanks Allen however aftern placing some text in the Validation Text property ... > Whatever message you wish to display, you can place in the Validation Text ... > property of the table (Properties box in table design view.) ... > changing the sort order, closing the form, closing Access, pressing ...
    (microsoft.public.access.formscoding)
  • Am I crazy?
    ... VB6 application with SQL server approx 10 users. ... ADO control bound to a datagrid. ... Continual validation for several fields in the WillMove/MoveComplete (this ... idea to do this with such a large recordset and so much validation. ...
    (microsoft.public.data.ado)
  • Re: .NET2.0: Microsoft, you got something very wrong in data validation..
    ... The constraint check is a type of validation - and it already ... columns are in error (but i'd have expected a ConstraintException to ... its underlying data chain contains "oldvalue" at every other step. ... If this is a design no-no then do let me know ...
    (microsoft.public.dotnet.framework.adonet)
Loading