Re: slow process when I save a new record

From: Jerry III (jerryiii_at_hotmail.com)
Date: 02/23/04

  • Next message: Victor Koch: "Re: slow process when I save a new record" 
    Date: Mon, 23 Feb 2004 12:28:40 -0800

    The best approach is not to use clustered indexes and to use as little
    indexes as you can. Unfortunatelly you left that information out...

    Oh and splitting the table will not make it faster as now more tables and
    indexes have to be updated.

    Jerry

    "Tsevy" <anonymous@discussions.microsoft.com> wrote in message
    news:3297E887-4EEE-4112-AFF8-46387322AE2A@microsoft.com...
    > Hi
    > I designed form with 35 text_boxes
    >
    > I have a table with 40.000 records and with 35 fields
    > when I save a new record it took 3 minutes
    >
    > I decided to split this table (35 fileds) into 7 tables (with only 5
    fields each)
    > I minimize the length on each field ( text max 50)
    >
    >
    >
    > I created 7 recordsets for each table . mors_1.and / Strsql = Select *
    from tbl_1
    > and I saved the new record into 7 tables
    >
    > A .. firs I save tbl_1
    > tbl_1 primary key is " auto number "
    > B. then I save tbl_2
    > tbl_2 primary keys is >> primary keys from tbl_1
    >
    > C Then I save tbl_3.......
    > tbl_3 primary keys is >> primary keys from tbl_1...4,5,6,7
    >
    >
    > is still taking around 5 minutes to save all this tables
    >
    >
    > What will be the best approach to save faster
    >
    > Thanks
    >
    > TA
    >

  • Next message: Victor Koch: "Re: slow process when I save a new record"