fetch image and filter

Next topic

Author	Message
stephane couzinier	Saturday 23 December 2006 1:58:50 am It will be use full to filter/sort image by ratio (width/height) Actually the width and height are store on a XML fields, but there is no way to make a fast SQL query. With a photo Gallery , sometime I need to find the first image with a ratio greater than 1 another I need to display an image width a ratio less than 1. To resolve this pb: - I create a new table ( i store the id,width,height,ratio of all images) - Every time a image is upload, I update my table - I add a new extended attribute filter to get images by ratio It's work, but It's will be better for me ;-) to have this on ez don't flush the cache
alan robert	Monday 02 April 2007 9:07:17 am This is good idea, I just need something like this, but I don't use sort image by ratio, I need use table to control image for another using. do you can provide your code or demo in somewhere? Thanks in advance. http://www.softsea.com/
Janet Kellman	Sunday 08 July 2007 3:20:13 am alan robert, I also need something like this. can you write code example for using ? thanks! http://rbytes.net/software/

Author

Message

Saturday 23 December 2006 1:58:50 am

It will be use full to filter/sort image by ratio (width/height)
Actually the width and height are store on a XML fields, but there is no way to make a fast SQL query.

With a photo Gallery , sometime I need to find the first image with a ratio greater than 1 another I need to display an image width a ratio less than 1.

To resolve this pb:
- I create a new table ( i store the id,width,height,ratio of all images)
- Every time a image is upload, I update my table
- I add a new extended attribute filter to get images by ratio

It's work, but It's will be better for me ;-) to have this on ez

don't flush the cache

alan robert

Monday 02 April 2007 9:07:17 am

This is good idea, I just need something like this,
but I don't use sort image by ratio, I need use table to control image for another using.

do you can provide your code or demo in somewhere?

Thanks in advance.

http://www.softsea.com/

Janet Kellman

Sunday 08 July 2007 3:20:13 am

alan robert, I also need something like this. can you write code example for using ?
thanks!

http://rbytes.net/software/

eZ debug

Timing:	Jan 18 2025 11:00:29
Script start
Timing:	Jan 18 2025 11:00:29
Module start 'layout'
Timing:	Jan 18 2025 11:00:29
Module start 'content'
Timing:	Jan 18 2025 11:00:29
Module end 'content'
Timing:	Jan 18 2025 11:00:29
Script end

Main resources:

Total runtime	0.0165 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	589.0234	152.6250
Module start 'layout'	0.0057	0.0036	741.6484	39.4453
Module start 'content'	0.0093	0.0050	781.0938	89.1953
Module end 'content'	0.0142	0.0022	870.2891	30.3047
Script end	0.0164		900.5938

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	15.8995	14	0.0002
Check MTime	0.0012	7.3268	14	0.0001
Mysql Total
Database connection	0.0006	3.5859	1	0.0006
Mysqli_queries	0.0036	21.7311	3	0.0012
Looping result	0.0000	0.0985	1	0.0000
Template Total	0.0018	11.1	1	0.0018
Template load	0.0008	5.0434	1	0.0008
Template processing	0.0010	6.0098	1	0.0010
Override
Cache load	0.0006	3.6033	1	0.0006
General
dbfile	0.0003	1.8458	8	0.0000
String conversion	0.0000	0.0493	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs