Re: Need help with LONG RAW format

From: Daniel White <dwhite_at_spammer.radix1.demon.co.uk>
Date: Fri, 03 Jul 1998 02:02:30 GMT
Message-ID: <359c3ba1.206276216@news.demon.co.uk>

What is your indexing strategy on the table ?

On Fri, 3 Jul 1998 08:28:26 +0700, "TSP Fossa" <sonnypf_at_ymmi.co.id> wrote:

>Hi ...
>
>I've create a table employee with these settings :
>
>Name Null? Type
>------------------------------- -------- ----
>ID NOT NULL VARCHAR2(7)
>NAME VARCHAR2(40)
>JOB_ID VARCHAR2(7)
>ORG_ID VARCHAR2(4)
>MARITAL_STATUS VARCHAR2(2)
>TAX_STATUS VARCHAR2(2)
>DRIVER_LICENSE VARCHAR2(20)
>CITIZEN_ID_CARD VARCHAR2(30)
>PHONE VARCHAR2(25)
>IN_DATE DATE
>PHOTO LONG RAW
>EMP_STATUS_TYPE VARCHAR2(1)
>FLAG_STATUS VARCHAR2(1)
>
>and I made forms to insert bmp photo to column PHOTO. But as the number of
>employee grows ( and so do the number of photos, each about 50 kb ),
>querying records from the employee table needs more time ( querying a record
>can be up to 1 minute ).
>Can anybody help me how to speed up the query.
>I've tried setting photo to NULL in the employee table, and put the photo in
>another table but it didn't give any significant difference.
>
>

Daniel White

---

Dan's Hong Kong Movies Page
www.radix1.demon.co.uk Received on Thu Jul 02 1998 - 21:02:30 CDT