Lionel Bouton wrote:> Daniel Smedegaard Buus wrote the following on 27.11.2006 11:52 :
> > I''m trying to speed up my app by caching models so that the
SQL server
> > gets a lower hit rate.
> >
>
> This might seem obvious, but are the memcache servers really running and
> listening on these ports? What are the logs telling in development mode
> (do you see memcache-client debug messsages)?
>
Hmm... Sorry, I don''t know! :| How do I find out if the servers are
running?
Here''s one from the log (there are no messages matching
"memcache"):
Processing ItemsController#show (for 10.10.10.110 at 2006-11-27
11:37:14) [GET]
Session ID: cf1eb549ae1b91820ef4b280148f86a9
Parameters: {"action"=>"show",
"id"=>"9780192828606",
"controller"=>"items"}
[4;36;1mItem Columns (0.078000) [0m [0;1mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH(''Item'', COLUMN_NAME) as
Length,
COLUMNPROPERTY(OBJECT_ID(''Item''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Item'' [0m
[4;35;1mSQL (0.016000) [0m [0mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH(''Item'', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''Item''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Item'' [0m
[4;36;1mItem Load (9.375000) [0m [0;1mSELECT TOP 1 * FROM
PolyBook.Item WHERE (PolyBook.Item.Itemnumber = 9780192828606) [0m
Rendering within layouts/items
Rendering items/show
[4;35;1mPublisher Columns (0.000000) [0m [0mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH(''Publisher'',
COLUMN_NAME) as
Length, COLUMNPROPERTY(OBJECT_ID(''Publisher''), COLUMN_NAME,
''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ''Publisher'' [0m
[4;36;1mSQL (0.000000) [0m [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH(''Publisher'', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''Publisher''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Publisher'' [0m
[4;35;1mPublisher Load (0.000000) [0m [0mSELECT TOP 1 * FROM
PolyBook.Publisher WHERE (PolyBook.Publisher.PublisherID = 1) [0m
[4;36;1mSeries Columns (0.016000) [0m [0;1mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH(''Series'', COLUMN_NAME)
as Length,
COLUMNPROPERTY(OBJECT_ID(''Series''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Series'' [0m
[4;35;1mSQL (0.031000) [0m [0mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH(''Series'', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''Series''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Series'' [0m
[4;36;1mSeries Load (0.000000) [0m [0;1mSELECT PolyBook.Series.*
FROM PolyBook.Series INNER JOIN PolyBook.SeriesItem ON
(PolyBook.Series.SeriesID) = (PolyBook.SeriesItem.SeriesID) WHERE
((PolyBook.SeriesItem.ChildItemnumber = ''9780192828606'')) [0m
[4;35;1mAuthor Columns (0.015000) [0m [0mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH(''Author'', COLUMN_NAME)
as Length,
COLUMNPROPERTY(OBJECT_ID(''Author''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Author'' [0m
[4;36;1mSQL (0.000000) [0m [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH(''Author'', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''Author''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''Author'' [0m
[4;35;1mAuthor Load (0.016000) [0m [0mSELECT PolyBook.Author.*
FROM PolyBook.Author INNER JOIN PolyBook.AuthorRankTypeItem ON
(PolyBook.Author.AuthorID) = (PolyBook.AuthorRankTypeItem.AuthorID)
WHERE ((PolyBook.AuthorRankTypeItem.Itemnumber =
''9780192828606''))
ORDER BY AuthorRank [0m
[4;36;1mAudienceRangeCode Columns (0.015000) [0m [0;1mSELECT
COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as
ColType, IS_NULLABLE As IsNullable,
COL_LENGTH(''AudienceRangeCode'',
COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''AudienceRangeCode''),
COLUMN_NAME, ''IsIdentity'') as IsIdentity, NUMERIC_SCALE as
Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME =
''AudienceRangeCode'' [0m
[4;35;1mSQL (0.031000) [0m [0mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH(''AudienceRangeCode'', COLUMN_NAME) as
Length,
COLUMNPROPERTY(OBJECT_ID(''AudienceRangeCode''), COLUMN_NAME,
''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME =
''AudienceRangeCode'' [0m
[4;36;1mAudienceRangeCode Load (0.000000) [0m [0;1mSELECT
PolyBook.AudienceRangeCode.* FROM PolyBook.AudienceRangeCode INNER JOIN
PolyBook.AudienceRangeItem ON
(PolyBook.AudienceRangeCode.AudienceRangeCode)
(PolyBook.AudienceRangeItem.AudienceRangeCode) WHERE
((PolyBook.AudienceRangeItem.Itemnumber = ''9780192828606''))
[0m
[4;35;1mEditionType Columns (0.031000) [0m [0mSELECT COLUMN_NAME
as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH(''EditionType'',
COLUMN_NAME) as
Length, COLUMNPROPERTY(OBJECT_ID(''EditionType''), COLUMN_NAME,
''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ''EditionType''
[0m
[4;36;1mSQL (0.032000) [0m [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH(''EditionType'', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''EditionType''), COLUMN_NAME,
''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''EditionType'' [0m
[4;35;1mEditionType Load (0.000000) [0m [0mSELECT
PolyBook.EditionType.* FROM PolyBook.EditionType INNER JOIN
PolyBook.EditionItem ON (PolyBook.EditionType.EditionTypeCode)
(PolyBook.EditionItem.EditionTypeCode) WHERE
((PolyBook.EditionItem.Itemnumber = ''9780192828606'')) [0m
Completed in 10.29700 (0 reqs/sec) | Rendering: 0.12600 (1%) | DB:
9.65600 (93%) | 200 OK [http://psrv4/items/show/9780192828606]
> Lionel
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---