Re: R: [PERFORM] Very slow bytea data extraction

2007-02-23 Thread Merlin Moncure
On 2/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Thanks for your reply, >Is it in executing the query (what does EXPLAIN ANALYSE show)? Here is the output of explain analyze SELECT * FROM "FILE" "Seq Scan on "FILE" (cost=0.00..1.36 rows=36 width=235) (actual time=0.023..0.107 rows=36

Re: R: [PERFORM] Very slow bytea data extraction

2007-02-23 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Thanks for your reply, Is it in executing the query (what does EXPLAIN ANALYSE show)? Here is the output of explain analyze SELECT * FROM "FILE" "Seq Scan on "FILE" (cost=0.00..1.36 rows=36 width=235) (actual time=0.023..0.107 rows=36 loops=1)" If you look at

R: [PERFORM] Very slow bytea data extraction

2007-02-23 Thread [EMAIL PROTECTED]
Thanks for your reply, >Is it in executing the query (what does EXPLAIN ANALYSE show)? Here is the output of explain analyze SELECT * FROM "FILE" "Seq Scan on "FILE" (cost=0.00..1.36 rows=36 width=235) (actual time=0.023..0.107 rows=36 loops=1)" >How are you accessing the database: odbc,